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-00403: %s (string) is not the same as other instances (string)

1 Answers  


PLS-00507: a PLSQL Table may not contain a table or a record with composite fields

2 Answers  


ORA-01632: max # extents (string) reached in index string.string

1 Answers  


PLS-01409: Use of 'PRIOR_' token

1 Answers  


ORA-13769: Snapshots string and string do not exist.

1 Answers  


ORA-07572: szrfc: insufficient rolename buffer space

1 Answers  


NNO-00809: Unknown OCI error: number

1 Answers  


DRG-12433: load of string JDBC driver class failed

1 Answers  


ORA-25226: dequeue failed, queue string.string is not enabled for dequeue

1 Answers  


DRG-10304: unexpected error sending command(s) to Oracle Text server

1 Answers  


ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

3 Answers  


ORA-01215: enabled thread string is missing after CREATE CONTROLFILE

1 Answers  


Categories