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();