2008-02-21

PLS-00320 in the definition of a record

Today I got this error when defining a record type:

PLS-00320: the declaration of the type of this expression is incomplete or malformed

TYPE trec_logins IS RECORD (
login gi_logins.login%TYPE,
id gi_logins.ID%TYPE,
estado gi_logins.status%TYPE,
gi_person gi_person.name%TYPE
);


What is the reason for this error?
In this case the reason was that you can't define as a record atribute name the same name as a table that is used in the definition of some atribute of the record (i.e. gi_person).

No comments:

Post a Comment

Os comentários são moderados.
The comments are moderated.