This discussion is archived
2 Replies Latest reply: Feb 20, 2013 1: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,
table1.b,
table2.c,
SP_another_proc(table1.a,table1.b,d,e)
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 VB.net)

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

Legend

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