Home » SQL & PL/SQL » SQL & PL/SQL » call a function which returns multiple values
call a function which returns multiple values [message #443221] Sat, 13 February 2010 16:13 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
I have a function created by some third party, I have to call this inside my own funnction

SEC_MGR.verifyEAVSauth (i_sys_session_id in number,
s_USERNAME out varchar2,
s_USERPASSWORD out varchar2,
s_DATABASE_INSTANCE out varchar2,
res out varchar2)

all the examples calling functions return single value how to handle a function which retuns multilpe values ?

I tried this but it does not work


declare
v_username VARCHAR2(25);
v_userpassword VARCHAR2(25);
v_database_instance VARCHAR2(25);
v_res VARCHAR2(25);
begin
SEC_MGR.verifyEAVSauth (150,v_username,v_userpassword,v_database_instance,v_res);

end;

Re: call a function which returns multiple values [message #443222 is a reply to message #443221] Sat, 13 February 2010 16:18 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I tried this but it does not work

My car does not work.
Please tell me how to make my car go.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.


>all the examples calling functions return single value how to handle a function which retuns multilpe values ?

A FUNCTION, by definition, only returns a single scalar value.

[Updated on: Sat, 13 February 2010 16:20]

Report message to a moderator

Re: call a function which returns multiple values [message #443246 is a reply to message #443221] Sun, 14 February 2010 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I tried this but it does not work

The block you posted does not show the returned values, how can you know "it does not work"?
What does mean "it does not work"?

111 posts and you still don't know to post.
Read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Regards
Michel
Re: call a function which returns multiple values [message #443247 is a reply to message #443222] Sun, 14 February 2010 00:52 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
A FUNCTION, by definition, only returns a single scalar value.

It returns one value in its return clause but it does not need to be scalar; and also it can return other values in OUT paramaters.

Regards
Michel
Previous Topic: schema and user
Next Topic: Cartesian Product query
Goto Forum:
  


Current Time: Sat Dec 10 08:41:29 CST 2016

Total time taken to generate the page: 0.12493 seconds