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
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