Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06550,PLS-00201 error (oracle 10g )
icon9.gif  ORA-06550,PLS-00201 error [message #411488] Sat, 04 July 2009 05:06 Go to next message
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 #411491 is a reply to message #411488] Sat, 04 July 2009 05:15 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Can you provide calling function code and called function code with well formatted error message?
This will help us in understanding your problem better and can help you in better way.
Just copy and paste your SQL Plus session.

regards,
Delna
Re: ORA-06550,PLS-00201 error [message #411512 is a reply to message #411488] Sat, 04 July 2009 09:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Re: ORA-06550,PLS-00201 error [message #411518 is a reply to message #411512] Sat, 04 July 2009 09:52 Go to previous messageGo to next message
d_yadav
Messages: 4
Registered: March 2009
Location: INDIA
Junior Member
Hi Michel,
Thanks for valuable response.
Re: ORA-06550,PLS-00201 error [message #411519 is a reply to message #411488] Sat, 04 July 2009 10:09 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Posting Guidelines state:

"If you found an answer yourself, post it. That way we know the issue is resolved and we might learn from it."

[Updated on: Sat, 04 July 2009 10:09]

Report message to a moderator

Previous Topic: call procedure with OUT parameter inside another procedure
Next Topic: Difference in DML operations on Table and Global temp table
Goto Forum:
  


Current Time: Sat Dec 10 07:08:02 CST 2016

Total time taken to generate the page: 0.07853 seconds