permaculture playing cards*
The moose likes Java in General and the fly likes Call a stored procedure via JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Call a stored procedure via JDBC" Watch "Call a stored procedure via JDBC" New topic
Author

Call a stored procedure via JDBC

Bechir Bejaoui
Greenhorn

Joined: Feb 06, 2013
Posts: 7
Hi folks

I need to call a stored procedure from within the java code, I encountred the following error
ORA-00900: invalid SQL statement

I created a procedure that works perfectly I tested it in TOAD


This above procedure executes perfecty under toad



IT gives me res = 50 under toad

Now here is the code in java


This code gives me error exactly at this line



So how to fix that

Thank you







amit punekar
Ranch Hand

Joined: May 14, 2004
Posts: 511
Hello,
It seems you are not registering the out parameter.
Please check the javadocs and modify the code accordingly and it should work then.

regards,
Amit
Ishan Pandya
Ranch Hand

Joined: Feb 06, 2012
Posts: 219

String s="{call getTestData(?, ?)}"; //you have not used "call" to call procedure..

and OUT should be registered as amit said.
refer to this link Callable Statement


OCPJP
 
jQuery in Action, 2nd edition
 
subject: Call a stored procedure via JDBC
 
Similar Threads
Dynamically creating stored Procudure in JAVA
Large Numbers
Exception declaration not seen
creating a new JPanel from another JPanel "choice" button
trouble with loops and invoking a method