 ORA-06550,PLS-00201 error [message #411488] |
Sat, 04 July 2009 05:06  |
d_yadav
Messages: 4
Registered: March 2009
Location: INDIA |
Junior Member |
|
|
Hi All,
while i am calling package from appllicaton getting follwoing error
Warning: ociexecute() [function.ociexecute]: ORA-06550: line 1, column 7: PLS-00201: identifier 'BKP_PKG_INTER_HT_CRM_BILLING.PRO_COMBINED_ACTION_220609' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored in /usr/local/apache2/htdocs/pgvcl/htbill/ht_crm.php on line 50
kindly help.
|
|
|
|
| Re: ORA-06550,PLS-00201 error [message #411512 is a reply to message #411488] |
Sat, 04 July 2009 09:32  |
Michel Cadot
Messages: 28979
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| Quote: | PLS-00201: identifier "string" must be declared
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.
|
Regards
Michel
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
