Re: Q: jdbc and stored procedures returning several outparameters

Trond Kandal wrote:
> hello
>
> is there anyone who have used jdbc and stored procedures that
> returns more than one outparameter?
>
> i have looked at some examples from oracle but they uses only
> one outparameter.
>
> ex:
>
> CallableStatement cs = conn.prepareCall ("begin ? := foo(?); end;");
> cs.registerOutParameter(1,Types.CHAR);
> cs.setString(2, "aa");
> cs.executeUpdate();
> String result = cs.getString(1);
>
> how do i write the code when i want to get more than one
> outparameter?
>
> thanks!
>
>
> trond.

You can try posting this in lang.java.databases

Not sure how it's done in JDBC. Why dont you try using registerOutParameter(2,..) and so on for all the OUT parameter positions!

Amogh Received on Wed Sep 28 2005 - 03:32:44 CDT