Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00201: identifier 'string' must be declared



PLS-00201: identifier 'string' must be declared..

Answer / guest

Cause: You tried to reference either an undeclared variable,
exception, procedure, or other item, or an item to which no
privilege was granted or an item to which privilege was
granted only through a role.

Action: 1) Check your spelling and declaration of the
referenced name. 2) Verify that the declaration for the
referenced item is placed correctly in the block structure.
3) If the referenced item is indeed declared but you don't
have privileges to refer to that item, for security reasons,
you will be notified only that the item is not declared. 4)
If the referenced item is indeed declared and you believe
that you have privileges to refer to that item, check the
privileges; if the privileges were granted only via a role,
then this is expected and documented behavior. Stored
objects (packages, procedures, functions, triggers, views)
run in the security domain of the object owner with no roles
enabled except PUBLIC. Again, you will be notified only that
the item was not declared.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00106: Unable to open INCLUDE file "string"

1 Answers  


ORA-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

1 Answers  


ORA-07244: ssfccf: create file failed, file size limit reached.

1 Answers  


IMP-00090: Unexpected DbmsJava error number at step number while creating string

1 Answers  


ORA-02336: column attribute cannot be accessed

1 Answers  






ORA-02398: exceeded procedure space usage

1 Answers  


ORA-04068: existing state of packagesstringstringstring has been discarded

1 Answers  


PCC-02144: CMD-LINE: Blank characters are not allowed on either side of an equal sign (=)

1 Answers  


NCR-03024: NCRO: Transport type LIST not supported

1 Answers  


ORA-07756: slemcf: fread failure

1 Answers  


ORA-22343: Compilation error for type invalidated by ALTER TYPE

1 Answers  


ORA-26007: invalid value for SETID or OID column

1 Answers  






Categories