Re: read values from REF CURSOR

From: Eca Eca <ecaeser_at_hotmail.com>
Date: Sat, 04 Aug 2001 02:15:39 -0700
Message-ID: <F001.0036090F.20010804012509@fatcity.com>

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
eriovaldo.andrietta_at_widesoft.com.br

>From: "Don Dealy II" <dondealy_at_teleport.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: dondealy_at_teleport.como
>

---

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: ecaeser_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Received on Sat Aug 04 2001 - 04:15:39 CDT