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
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