Re: Cursor as a return parameter in stored procedure?

A copy of this was sent to "Carl Williams" <carl.williams_at_postoffice.co.uk> (if that email address didn't require changing) On Tue, 15 Feb 2000 14:44:09 -0000, you wrote:

>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
>

see http://osi.oracle.com/~tkyte/ResultSets/index.html

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation