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

PCC-00098: Scale specification cannot be used in this context

1 Answers  


NID-00350: string (number) string

1 Answers  


ORA-13436: GeoRaster metadata dimensionSize error

1 Answers  


ORA-30501: instance shutdown triggers cannot have AFTER type

1 Answers  


ORA-16610: one or more resources have warnings

1 Answers  


ORA-28101: policy already exists

1 Answers  


ORA-01908: EXISTS keyword expected

1 Answers  


ORA-12911: permanent tablespace cannot be temporary tablespace

1 Answers  


ORA-24776: cannot start a new transaction

1 Answers  


ORA-39058: current object skipped: string of type string

1 Answers  


RMAN-04006: error from auxiliary database: string

1 Answers  


ORA-32634: automatic order MODEL evaluation does not converge

1 Answers  


Categories