FileDocCategorySizeDatePackage
PublishTestDefaultConnection2.javaAPI DocExample747Sat Oct 28 16:25:48 BST 2000None

PublishTestDefaultConnection2.java

import java.sql.*;

class PublishTestDefaultConnection2 {

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