Home » Developer & Programmer » JDeveloper, Java & XML » Stored Function with 3 out parameters
Stored Function with 3 out parameters [message #91402] Tue, 13 August 2002 05:36 Go to next message
Michael Szalay
Messages: 1
Registered: August 2002
Junior Member

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

Re: Stored Function with 3 out parameters [message #91747 is a reply to message #91402] Thu, 30 January 2003 19:07 Go to previous message
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.
Previous Topic: Re: Logical handle no longer valid
Next Topic: Re: Fail to convert between UTF8 and UCS2: failUTF8Conv
Goto Forum:

Current Time: Wed Nov 30 18:24:26 CST 2022