Re: Fetching from a cursor variable.

In article <4e4svr$cp0_at_berta.dde.dk>, mj_at_dde.dk (Martin Jensen) writes:
> Hi there.
>
> I thought the PLSQL 2.2 from Oracle7 7.2.2.3 would allow me not only to declare
> variables of a cursor type but also to fetch from it!
>
> Can anyone see if I am doing something wrong here - or is this feature
> to be expected in a later release?
>
> Running:
> Oracle7 Server Release 7.2.2.3.0 - Production Release
> With the distributed, replication and parallel query options
> PL/SQL Release 2.2.2.3.0 - Production

*snip*

You can select from them in 7.2, but only from 3gl's. You'll have to wait until 7.3 (v2.3 PL/SQL) before you can do it in PL/SQL. That also means that you will not be able to do it in Developer2000, as that still uses PL/SQL v1. I'll put in a plug for Steven Feuersten's book here, as he describes what features are available in the various versions. It's also got quite a bit of good info not found in Oracle manuals for anyone contemplating much server programming.

David Jordan
DBA
Ford Motor Company Received on Mon Jan 29 1996 - 00:00:00 CET