Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00320

user8660054Aug 14 2012 — edited Aug 14 2012
Hi all,

when I try to compile a package body I receive following error:

[Error] PLS-00320 (1466: 5): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (1475: 37): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] ORA-00904 (1475: 37): PL/SQL: ORA-00904: "LV_ID_LIMIT": invalid identifier

I have variable declared as you can see below.
lv_id_limit radis.sif_lim_radis.id_limit%type;

I have the same code on testing environment where it compiles just fine. Any help would be appreciated.

Regards,
Robert
This post has been answered by 908002 on Aug 14 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2012
Added on Aug 14 2012
2 comments
565 views