This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
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
John Bateman
Ranch Hand
Joined: Mar 09, 2000
Posts: 320
posted
0
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.
suzi lu
Greenhorn
Joined: Jan 05, 2001
Posts: 17
posted
0
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
Thomas Paul
mister krabs
Ranch Hand
Joined: May 05, 2000
Posts: 13974
posted
0
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.
0
