FileDocCategorySizeDatePackage
PublishTestExternalConnection.javaAPI DocExample746Mon Oct 30 17:21:16 GMT 2000None

PublishTestExternalConnection.java

import java.sql.*;

class PublishTestExternalConnection {

 public static void main(String[] argv)
  throws SQLException {
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  String sql = "create or replace function TEC_getGreeting " + 
               "return varchar2 " + 
               "as language java " + 
               "name 'TestExternalConnection.getGreeting() " + 
               "return java.lang.String';";
  Connection conn = DriverManager.getConnection(
    "jdbc:oracle:thin:dssw2k01:1521:orcl", "scott", "tiger");
  Statement  stmt = conn.createStatement(); 
  long       rslt = stmt.executeUpdate(sql);
  if (rslt==0) 
   System.out.println("OK");
  stmt.close();
  conn.close();
 }
}