Re: Cursor as a return parameter in stored procedure?

http://osi.oracle.com/~tkyte/resultsets.

Hth,

Sybrand Bakker, Oracle DBA

Carl Williams <carl.williams_at_postoffice.co.uk> wrote in message news:950625916.542813_at_igateway.postoffice.co.uk...
> 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