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

Home -> Community -> Usenet -> c.d.o.misc -> Cursor variables in packages

Cursor variables in packages

From: Walter Dnes <waltdnes_at_interlog.com>
Date: Mon, 05 Jul 1999 00:10:27 GMT
Message-ID: <377ff279.8853434@news.interlog.com>


  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???



SQL*Plus: Release 8.0.4.0.0 - Production on Sun Jul 4 19:38:46 1999

(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

Original text of this message

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