I have a stored proc which takes 5 parameters , does some manipulation and returns me a record set.How do i call that in JDBC? callablestatement c = stmt.preparecall("call sp_myproc(?,?,?,?,?)") and say setXXX for all the five parameters....and say resultset rs = c.execute() and then manipulate the resultset??? Am i correct??? Pl help... Tx, Suzi
Joined: Mar 09, 2000
Hey My only comment to you would be.. what happens when you actually do that? Let us know IF it doesn't work.
SOURCE CODE should be SURROUNDED by "code" tags.
Joined: Jan 05, 2001
I mean if I have a stored proc returning a resultset, taking in 5 parameters, then do i have to say, c.registeroutparameter for resultset???(i would say setXXX() for input params anyways) Pl help me Tx, Suzi
Joined: May 05, 2000
then do i have to say, c.registeroutparameter for resultset???
That's only used if your parameters are defined as out or inout parameters. Your original post had all the required steps.