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

AMD-00106: parent string "string" must be removed before child string "string" can be removed

1 Answers  


ORA-15111: conflicting or duplicate STRIPE options

1 Answers  


RMAN-08135: some corrupt blocks found during conversion of file string

1 Answers  


PLS-00489: invalid table reference: 'string' must be a column in this expression

1 Answers  


PCC-02421: This host variable requires the use of an indicator variable

1 Answers  


ORA-32154: Anydata context not specified

1 Answers  


ORA-01045: user string lacks CREATE SESSION privilege; logon denied

1 Answers  


PCB-00002: Command line processor severe error

1 Answers  


NNL-00851: Renames refused, name is not a leaf name: number

1 Answers  


ORA-12820: invalid value for DEGREE

1 Answers  


TNS-01306: nt secondary err code: number

1 Answers  


O2F-00337: Schema not found, or no types found in schema

1 Answers  


Categories