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

RMAN-06135: error executing host command: string

1 Answers  


DRG-50907: score threshold string outside valid range 1 to 100

1 Answers  


ORA-31424: change table has active subscriptions

1 Answers  


ORA-28601: invalid [no]MINIMIZE option

1 Answers  


RMAN-20001: target database not found in recovery catalog

2 Answers  


ORA-19812: cannot use string without DB_RECOVERY_FILE_DEST

1 Answers  


RMAN-08112: archivelog failover was done on string, check alert log for more info

1 Answers  


RMAN-06576: platform 'string' (number) found in header of datafile string does not mmatch specified platform name 'string' (number)

1 Answers  


ORA-39019: invalid operation type string

1 Answers  


ORA-00365: the specified log is not the correct next log

1 Answers  


ORA-25255: incorrect subscription string string

1 Answers  


ORA-19569: no device is allocated to this session

1 Answers  


Categories