wood burning stoves 2.0*
The moose likes JDBC and the fly likes Callable Statements Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Callable Statements" Watch "Callable Statements" New topic
Author

Callable Statements

Sumeet Anand
Greenhorn

Joined: Nov 16, 2002
Posts: 16
Hi All,
I am using callable statements to execute stored procs.But I have a doubt.Suppose we call a stored proc as :
CallableStatement cstmt = con.prepareCall( "{ call sp_C( ? ? ? ) }" );
Now whether the question mark placeholders are the total parameters(sum of input and output parameters)or just the output parameters.
Please clarify.
Thanks in advance.
Sumeet.
vishwas bansal
Greenhorn

Joined: Dec 19, 2002
Posts: 6
its sum of input and output params.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Callable Statements
 
Similar Threads
Problems with Callable Statement in Sybase
Issue calling a stored procedure from Weblogic 8.1 workshop project
callable statement
Returning Result Sets from Pl/SQL to Java
Callable Statement