Calling a Stored Procedure within a Procedure

Posted in 1999

Topics: Stored Procedures & SPL, Platform-Specific Issues, Jobs, Consulting & Announcements

Richard Auslander — Wed, 03 Nov 1999 16:15:15 -0800 — source: Informix-list mailing list archive (1991-1998)

Greetings All - This one seems to be either poorly or non-documented, so I thought perhaps someone out there would be kind enough to help. We're using Dynamic Server 7.30UC5 on Solaris. All I'm trying to do is call a stored procedure from within another stored procedure. That seems straightforward enough, but the child (inner) stored procedure returns a *SET* of rows, using the "with resume" clause. I don't see any documented or compilable way (I tried "FOREACH...END FOREACH", but got syntax errors) to receive that result set in the calling (parent) procedure. Thanks again for everyone's help! Rich -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com

↪ replying to Richard Auslander

Richard Auslander — Wed, 03 Nov 1999 17:12:43 -0800 — source: Informix-list mailing list archive (1991-1998)

Oops, never mind ... my mistake, somebody please RTFM me. Rich Richard Auslander wrote: > Greetings All - > > This one seems to be either poorly or non-documented, so I thought > perhaps someone out there would be kind enough to help. We're using > Dynamic Server 7.30UC5 on Solaris. All I'm trying to do is call a > stored procedure from within another stored procedure. That seems > straightforward enough, but the child (inner) stored procedure returns a > *SET* of rows, using the "with resume" clause. I don't see any > documented or compilable way (I tried "FOREACH...END FOREACH", but got > syntax errors) to receive that result set in the calling (parent) > procedure. Thanks again for everyone's help! > > Rich > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com

↪ replying to Richard Auslander

EA — Thu, 4 Nov 1999 13:57:55 +0100 — source: Informix-list mailing list archive (1991-1998)

RTFM You're welcome. ;-) Cheers Eckard Richard Auslander <rich@airflash.com> wrote in message news:3820DD8B.DCD19B41@airflash.com... > Oops, never mind ... my mistake, somebody please RTFM me. > > Rich > > Richard Auslander wrote: > > > Greetings All - > > > > This one seems to be either poorly or non-documented, so I thought > > perhaps someone out there would be kind enough to help. We're using > > Dynamic Server 7.30UC5 on Solaris. All I'm trying to do is call a > > stored procedure from within another stored procedure. That seems > > straightforward enough, but the child (inner) stored procedure returns a > > *SET* of rows, using the "with resume" clause. I don't see any > > documented or compilable way (I tried "FOREACH...END FOREACH", but got > > syntax errors) to receive that result set in the calling (parent) > > procedure. Thanks again for everyone's help! > > > > Rich > > -- > > Richard C. Auslander > > Database Manager > > > > AirFlash, Inc. > > 1733 Woodside Rd., Suite #110 > > Redwood City, CA 94061 > > (650) 556-7928 > > > > www.airflash.com > > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com > >