Need Help with Stored Procedure

From: Karla Dods <sticklan_at_bnr.ca>
Date: 19 Sep 1994 17:35:26 GMT
Message-ID: <35ki4u$6q7_at_bcarh8ab.bnr.ca>


I'm trying to run a multi-row select procedure within SQLPLUS and I am receiving the error message ORA-1422 exact fetch returns more than requested rows. Could someone please point me to an example which I can learn how to code a multi-row select procedure Your responses will be greatly appreciated.

Do I need a cursor in the database procedure?  If so how do I code it with the procedure statement?  

 Karla Dods
 763-8915
 Bell Northern Research Received on Mon Sep 19 1994 - 19:35:26 CEST

Original text of this message