OraFAQ Forum: SQL & PL/SQL » ORA-04067: not executed

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04067: not executed (Oracle 11.1.0.7.0 ,Unix-HP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04067: not executed [message #517358]

Mon, 25 July 2011 09:09

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

I am facing error in application.

ORA-04067: not executed ,procedure "BALA.SEQ_RR_ID" does not exist.

This procedure exist in database.There is one synonym with the name also exist in database.

Pls advice me how to resolve this error.

Thanks

Report message to a moderator

Re: ORA-04067: not executed [message #517359 is a reply to message #517358]

Mon, 25 July 2011 09:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: ORA-04067: not executed [message #517360 is a reply to message #517358]

Mon, 25 July 2011 09:13

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

balaji14 wrote on Mon, 25 July 2011 16:09

This procedure exist in database.There is one synonym with the name also exist in database.

Without proof of that, I believe your are wrong and Oracle is right.

Report message to a moderator

Re: ORA-04067: not executed [message #517382 is a reply to message #517360]

Mon, 25 July 2011 11:26

Barbara Boehmer
Messages: 9105
Registered: November 2002
Location: California, USA

Senior Member

Frequently when it says that some procedure does not exist it is because sufficient privileges have not been granted directly. If you are trying to execute this procedure from another procedure, then privileges granted through roles are not used. Another possibility is that the procedure was created using double quotes, making it case sensitive, so you have to use the right case and enclose it within quotes when executing it.

Report message to a moderator

Re: ORA-04067: not executed [message #517390 is a reply to message #517382]

Mon, 25 July 2011 11:57

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What you said, Barbara, is interesting but far above the understanding of OP.

Regards
Michel

Report message to a moderator

Re: ORA-04067: not executed [message #517564 is a reply to message #517390]

Tue, 26 July 2011 11:26

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Barbara,

Thank you for your explanations. You know.. rather than talking something and bluffing
and wasting our time ,your answer was useful.

Report message to a moderator

Re: ORA-04067: not executed [message #517566 is a reply to message #517564]

Tue, 26 July 2011 11:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/

please do #12

Report message to a moderator

Re: ORA-04067: not executed [message #517572 is a reply to message #517564]

Tue, 26 July 2011 11:52

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

balaji14 wrote on Tue, 26 July 2011 18:26

Barbara,

Thank you for your explanations. You know.. rather than talking something and bluffing
and wasting our time ,your answer was useful.

I really doubt you understood it.
Prove I am wrong and post what BlackSwan asked.

Regards
Michel

Report message to a moderator

Previous Topic:	read explain plan
Next Topic:	function that returns a table type inside a package body (9 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 27 17:03:01 CDT 2025