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-02380: profile string does not exist

1 Answers  


ORA-29915: cannot select FOR UPDATE from collection operand

1 Answers  


DRG-12437: highlight table release failed

1 Answers  


ORA-16156: LGWR archive log dependency not allowed if database is standby protected

1 Answers  


ORA-04077: WHEN clause cannot be used with table level triggers

1 Answers  


CLSR-01012: Invalid instance stop mode [string] is specified

1 Answers  


ORA-00253: character limit string exceeded by archive destination string string

1 Answers  


ORA-19506: failed to create sequential file, name="string", parms="string"

1 Answers  


ORA-19650: Offline-range record recid string stamp string in file string has SCN string

1 Answers  


ORA-06975: X.25 Driver: connect to host failed

1 Answers  


PLS-00601: partition extended object names may only be used with tables

1 Answers  


ORA-04070: invalid trigger name

1 Answers  


Categories