This discussion is archived
2 Replies Latest reply: Feb 20, 2013 9:08 PM by userLynx RSS

is there an ability to call another SP from within a cursor select?

userLynx Newbie
Currently Being Moderated
Can one do the following:

Open cursor XYZ
select table1.a,
from table1, table2
where table1.key = table2.key;

I want/need to select fields (d and e) from another procedure that is determined from fields a and b, and all 5 fields (a,b,c, d and e) are returned in the cursor (which will be used in

I'm using Oracle Database 11g Enterprise Edition Release - 64bit Production


  • Correct Answers - 10 points
  • Helpful Answers - 5 points