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

Home -> Community -> Usenet -> c.d.o.server -> Re: Ref Cursor

Re: Ref Cursor

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Fri, 20 Feb 2004 10:14:27 -0500
Message-ID: <bupZb.76$YV6.369@tor-nn1.netcom.ca>


Why ask twice?

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Alex" <alexk84_at_hotmail.com> a écrit dans le message de
news:57d3e820.0402192211.390e0aea_at_posting.google.com...

> I'm trying to execute a dynamic SQL statement using a ref cursor
> variable. The following is a simple example of what I'm trying to
> accomplish. I'd like to know how to declare the variable v_cur_dat to
> be able to accept any output, not only from table emp? Thanks in
> advance for your help.
>
> Alex
>
>
> DECLARE
>
> TYPE ref_cur_type IS REF CURSOR;
> v_cur ref_cur_type;
>
> v_cur_dat ??????
>
> BEGIN
> OPEN v_cur FOR SELECT * FROM emp;
>
> FETCH v_cur INTO v_cur_dat;
>
> END;
Received on Fri Feb 20 2004 - 09:14:27 CST

Original text of this message

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