Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL BUG?
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