Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Cursor as a return parameter in stored procedure?
Probably very easy, but it is giving me grief.
How do I write a simple stored procedure in Oracle 7.3.3.4 to return a cursor containing records...this is the code I have at the moment,( I have to expand on it later but I am keeping it simple for the moment), but I can't seem to find the correct way to add the cursor as a return parameter..
CREATE OR REPLACE PROCEDURE WCRM_GET_UNALLOC_INCIDENTS((Need the syntax here for the return cursor!)),LNGCAMPAIGNID IN INTEGER)
IS
CURSOR
ORS IS SELECT * FROM WCRM_INCIDENTS WHERE IN_CAMPAIGN_CODE = LNGCAMPAIGNID ;
BEGIN
OPEN ORS;
END;
Thanks in advance for any help.
Carl Williams
PLEASE REPLY TO CARL.WILLIAMS_at_POSTOFFICE.CO.UK
Received on Tue Feb 15 2000 - 00:00:00 CST
![]() |
![]() |