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-07632: smsrcx: $DELTVA failure

1 Answers  


NNL-00853: Renames refused, new name already exists: number

1 Answers  


TNS-12539: TNS:buffer over- or under-flow

1 Answers  


ORA-36820: (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.

1 Answers  


ORA-13625: %s is an invalid advisor object type.

1 Answers  


ORA-12718: operation requires connection as SYS

1 Answers  


ORA-00216: controlfile could not be resized for migration from 8.0.2

1 Answers  


ORA-31672: Worker process string died unexpectedly.

1 Answers  


RMAN-12018: channel string disabled, job failed on it will be run on another channel

1 Answers  


TNS-04050: Invalid specification for gateway ID.

1 Answers  


SQL*Loader-00518: Error reassembling file name (string)

1 Answers  


ORA-01083: value of parameter "string" is inconsistent with that of other instances

1 Answers  


Categories