Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010

    Question Unanswered: stored procedure returning multiple result sets(sybase)

    Hello All,

    I am new to stored procedure programming.I have the below mentioned scenario.

    I have got two stored procedures p1 and p2. from p1 I am calling p2.
    p2 returns two result set's. I need to store one of the result set returned by p2 to a temporary table in p1.

    p2 does not have any out parameter, it just has two select's which returns two resultset's.

    Please let me know if this is possible.

  2. #2
    Join Date
    Jun 2008
    I think this is not possible. A better approach is that creating temp table in p2 SP and inserting values in it. From P1, those results can be retrieved from the temp tables.

    These temp tables either may be temp tables or permanent tables. In the latter one, temp tables should be dropped explicitly.

Tags for this Thread

Posting Permissions

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