Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005

    Talking Unanswered: how to insert a Result set returned from a procedure..?


    I need a clarification regarding the result set returned by a stored procedure.

    Assume that i ve stored procedures AA and BB. Let BB returns a resultset ie.. it has a cursor defined in it and has some values collected in it during the execution of the procedure.

    I call the procedure BB from AA and I want to store those values returned by the procedure BB in a table, i use ' Associate result locators' and 'Allocate cursor' in the calling procedure AA. from the allocated cursor i fetch the values and then insert them in to the table.

    is there any simple way to do this...


  2. #2
    Join Date
    Nov 2004


    this is the easiest way todo.. even to get from sysproc sp we use this kind of code and never had a problem..
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts