Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Binding resultset of output of 2query and returing back from PL/SQL

Status
Not open for further replies.

manush

Programmer
Aug 9, 2004
16
IT
Hi,

I have two string containing two queries like
str1 VARCHAR2(1000);
str2 VARCHAR2(1000);

str1 := Select 'Test1' from dual;
str2 := Select 'Test2' from dual;

In PL/SQL, to get the result set of ONE query I use

OPEN o_result_set FOR str1;

Where o_result_set is IN OUT refcursor in stored procedure's parameter;

Now I have to get the out put of two different query, then to combine them and send it back via OUT parameter.

Pls suggest a solution

Manoj
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top