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 -> PL/SQL BUG?

PL/SQL BUG?

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Tue, 26 Oct 1999 14:17:33 +0100
Message-ID: <7v49mo$31k$1@ezekiel.eunet.ie>


Can anyone explain the following.

The following (declared in a package specification), fails to compile

TYPE phenomenontype_rec IS RECORD
(phenomenontype phenomenontype.phenomenontype%TYPE,

 memberid       indexingphenomenontype.memberid%TYPE,
 name           phenomenontype.name%TYPE,
 valuetype      phenomenontype.valuetype%TYPE,
 input          indexingphenomenontype.input%TYPE,
 purpose        phenomenontype.purpose%TYPE,
 sequence       indexingphenomenontype.sequence%TYPE );

however. the following declared instead of the above compiles = successfully.

TYPE phenomenontype_rec IS RECORD
(phenomenontype INTEGER,

 memberid       indexingphenomenontype.memberid%TYPE,
 name           phenomenontype.name%TYPE,
 valuetype      phenomenontype.valuetype%TYPE,
 input          indexingphenomenontype.input%TYPE,
 purpose        phenomenontype.purpose%TYPE,
 sequence       indexingphenomenontype.sequence%TYPE );

This appears to me to be a bug in PL/SQL(Oracle 7.3.4) . Can someone = confirm this, or otherwise give me a good explanation of why this is not = a bug. Received on Tue Oct 26 1999 - 08:17:33 CDT

Original text of this message

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