Friend :
I think you can use it :
CREATE OR REPLACE PACKAGE cv_types AS
TYPE DeptCurTyp is REF CURSOR RETURN dept%ROWTYPE;
END cv_types;
CREATE OR REPLACE PROCEDURE dept_rpt
(dept_cv IN OUT cv_types.DeptCurTyp) AS
BEGIN
OPEN dept_cv FOR SELECT * FROM DEPT;
END;
VARIABLE odcv REFCURSOR
EXECUTE dept_rpt(:odcv)
PRINT odcv
VARIABLE pcv REFCURSOR
EXECUTE dept_rpt(:pcv)
PRINT pcv
Eriovaldo
[EMAIL PROTECTED]
>From: "Don Dealy II" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: read values from REF CURSOR
>Date: Fri, 03 Aug 2001 22:35:26 -0800
>
>One of our web developers tells me that the values he is getting back from
>a REF CURSOR (dynamic SQL in 8.1.7 stored proc) is not returning the
>expected values.
>
>Naturally, all the blame is placed on the database and the "stupid" Oracle
>stored procedure, because it all works just fine in $QL $erver 2000.
>
>Is there any way that I can debug the stored proc and determine what values
>are being returned through the REF CURSOR? I want to know what is being
>sent out from Oracle, before it hits all the Micro$oft junque.
>
>I posted this same question on an iTar, but I hold little hope for an
>answer. After 5 days of silence I was told that "how to" questions are
>only answered when there is nothing else to do.
>
>Thanks for your help.
>
>
>Don
>e: [EMAIL PROTECTED]
>
_________________________________________________________________
Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus
amigos com o MSN Messenger em http://messenger.msn.com.br
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eca Eca
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
