| /* jdbckprb.sql */
/* Dated: 3-Jan-2001 */
/* Author: Teddy
Graham, teddy@exzilla.net */
/* Subject: Oracle
JDBC: Java Database Administration */
/* Edition: 1.0 */
/* */
CREATE OR REPLACE
JAVA SOURCE NAMED "jdbckprb" AS
import java.sql.*;
import oracle.jdbc.driver.*;
public class
jdbckprb {
static public
void test ()
throws SQLException
{
// Obtain the
connection for the server-side internal driver.
OracleDriver
ora = new OracleDriver();
Connection conn
= ora.defaultConnection();
System.out.println("Connected.");
// Create a
statement.
Statement stmt
= conn.createStatement();
// Do the SQL
"Hello World" thing.
ResultSet rset
= stmt.executeQuery(
"select 'Hello
OS user ' || osuser || ' on machine ' || machine || "
+
"' running program
' || program" +
" from v$session"
+
" where sid
= (select sid from v$mystat where rownum < 2)");
while (rset.next())
System.out.println(rset.getString(1));
System.out.println("Your
server-side internal JDBC connection succeeded.");
// Close the
result set and statement. Don't close the connection!
rset.close();
stmt.close();
}
}
/
CREATE OR REPLACE
PROCEDURE jdbckprb AS
LANGUAGE JAVA
NAME 'jdbckprb.test()';
/
set serveroutput
on format wrapped
CALL dbms_java.set_output(2000)
/
CALL jdbckprb()
/
|