Re: can a PL/SQL procedure return multiple records ?
From: Slurton <slurton_at_aol.com>
Date: 7 Dec 1994 20:40:31 -0500
Message-ID: <3c5o6f$3vf_at_newsbf01.news.aol.com>
Date: 7 Dec 1994 20:40:31 -0500
Message-ID: <3c5o6f$3vf_at_newsbf01.news.aol.com>
In article <James.Lawrence.41.000F4910_at_epamail.epa.gov>, James.Lawrence_at_epamail.epa.gov (Lawrence James) writes:
James,
Look in the PL/SQL guide and you will see that if you define a cursor and then start a loop and each time through the loop you fetch a new record the PL/SQL routine will retrieve several records for you.
Use a WHEN NO_DATA_FOUND condition to exit the loop.
Scott A. Lurton
Senior Scientist
Computer Resource Management, Inc.
Herndon, VA
USA
Received on Thu Dec 08 1994 - 02:40:31 CET