How to load Java Stored Procedure through JDBC into Oracle 10g? -
I'm trying to load an Oracle 10g database via JDBC and Java stored procedures. I am performing - I public class test {public static string mathim (string A) {return A; }};
It works fine through Todd works fine, but when I run through my JDBC client, the following error occurs -
exception in thread "Thread -2" Oracle on oracle.jdbc.driver.T4C8Oall.getNumRows (T4C8Oall.java:728) on oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout (OracleStatement) Java Oracle.jdbc.driver.lang.NullPointerException On .jdbc.driver.T4CStatement.execute_for_rows (T4CStatement.java:478). .java: 1028) on ejsdal.OperationController.run (oracle.jdbc.driver.OracleStatement.executeUpdate) on ejsdal.CreateDBJavaSQL.executeScript (CreateDBJavaSQL.java.2). (Operation Controller. Java 182) I'm using java.sql.Statement "executeUpdate" passing the string in the code block.
Is it possible to load the Java source via JDBC?
Think of it - sets need to
statement.setEscapeProcessing ( false); This is the Java source file before executing update because { and } characters call process by the JDBC driver syntax As has been incorrectly stated.
Comments
Post a Comment