Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Cursor as a return parameter in stored procedure?

Cursor as a return parameter in stored procedure?

From: Carl Williams <carl.williams_at_postoffice.co.uk>
Date: 2000/02/15
Message-ID: <950625916.542813@igateway.postoffice.co.uk>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US