| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Cursor variables in 7.2
In 7.2, cursor variables could only be returned to a client application for
fetching.... PL/SQL could not fetch from a cursor variable in that version (7.3
is the version that enabled that feature), only open them for fetching on the
client...
A copy of this was sent to ajayanand_at_my-dejanews.com (if that email address didn't require changing) On Wed, 28 Oct 1998 21:46:34 GMT, you wrote:
>Hi!,
>
>I tried executing these in Oracle7 Server Release 7.2.2.4.0, PL/SQL Release
>2.2.2.3.0. I was not able to do the fetch part. I get an error : Invalid
>cursor whereas this works on Oracle 8.0.
>
>Any suggestions ?? How could I get this working using PL/SQL on 7.2 ?
>
>create or replace package a_curtest as
>type cur_type is ref cursor return employee%rowtype;
>end;
>/
>
>create or replace procedure a_test_pkg(ecode employee.emp_code%type,emp_cv in
>out a_curtest.cur_type) as
>begin
>open emp_cv for select * from employee where emp_code = ecode ;
>end;
>/
>
>DECLARE
> lib_cv a_curtest.cur_type;
> emp_rec employee%ROWTYPE;
>BEGIN
>a_test_pkg(.000249,lib_cv);
>FETCH lib_cv INTO emp_rec;
>END;
>END;
>/
>
>Thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 29 1998 - 08:14:16 CST
 |
 |