| Stored Function with 3 out parameters [message #91402] |
Tue, 13 August 2002 05:36  |
Michael Szalay
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
Hello
I need to call a oracle stored function from JDBC. The function has two in parameters, a return value and two additional out parameters. How has the sql string to look like?
I tried
{? = call PACK_SPP_PROCESS_FUNC.sf_getSubscriberInfo(?, ?)}
The first ? represents the return value. Does anyone has an idea how I can retrieve the two additional out parameters?
Thank you
Michael
|
|
|
|
| Re: Stored Function with 3 out parameters [message #91747 is a reply to message #91402] |
Thu, 30 January 2003 19:07  |
Venkat
Messages: 110
Registered: February 2001
|
Senior Member |
|
|
I would use a stored procedure rather than a function if there is more than value to come out of it.
However registerOutParameter for each of three values,
one return value plus two out parameters may work here.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
