Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

ORA-00354: corrupt redo log block header

1 Answers  


TNS-12630: Native service operation not supported

1 Answers  


ORA-14002: only one GLOBAL clause may be specified

1 Answers  


ORA-02759: Not enough request descriptors available

1 Answers  


TNS-00241: Connection Manager: Logging is now OFF

1 Answers  


DRG-11709: too many terms in thesaurus

1 Answers  


RMAN-03028: fatal error code for command string : number

1 Answers  


DRG-10017: you must be string to do this: string

1 Answers  


ORA-00257: archiver error. Connect internal only, until freed.

1 Answers  


ORA-01116: error in opening database file string

1 Answers  


PLS-01466: Null strings are not allowed

1 Answers  


ORA-12476: least upper bound resulted in an invalid OS label

1 Answers  


Categories