This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

java and oracle

Posted by John Velu on May 01, 2001 at 4:23 PM

I have created a java stored procedure with a static method in it and uploaded it into an Oracle database. I have created a call spec procedure in SQL to call the java stored procedure. The java stored procedure is supposed to insert a record into a table. when I execute it, it says PL/SQL executed successfully, but I don't see any insertd record. I even tried "commit" after executing the procedure. Is it a security issue? or something else.

Thanks