Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Cursor variables in packages
According to Oracle's very own authorized
"ORACLE8 PL/SQL Programming"... 'In PL/SQL 2.2, cursor variables
cannot be declared in a package [...deletia...] This has been
lifted in PL/SQL 2.3". So ***WHY***, when I log on with client
version 8 onto a server running v8, does the following happen
when I execute dexpkg.sql, which tries to create a package spec
containing a cursor variable???
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Connected to:
Oracle8 Enterprise Edition Release 8.0.4.1.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.4.1.0 - Production
SQL> @dex\dexpkg
Warning: Package created with compilation errors.
Errors for PACKAGE DEX:
15/11 PLS-00994: Cursor Variables cannot be declared as part
of a package
15/11 PL/SQL: Declaration ignored
SQL>
--
Walter Dnes <waltdnes_at_interlog.com> procmail spamfilter
http://www.interlog.com/~waltdnes/spamdunk/spamdunk.htm
Why a fiscal conservative opposes Toronto 2008 OWE-lympics
http://www.interlog.com/~waltdnes/owe-lympics/owe-lympics.htm
Received on Sun Jul 04 1999 - 19:10:27 CDT
![]() |
![]() |