FileDocCategorySizeDatePackage
PublishTestDefaultConnection.javaAPI DocExample744Sat Oct 28 16:26:56 BST 2000None

PublishTestDefaultConnection.java

import java.sql.*;

class PublishTestDefaultConnection {

 public static void main(String[] argv)
  throws SQLException {
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  String sql = "create or replace function TDC_getGreeting " + 
               "return varchar2 " + 
               "as language java " + 
               "name 'TestDefaultConnection.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();
 }
}