2 Replies Latest reply on Feb 20, 2013 9:08 PM by userLynx

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

      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 VB.net)

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