Home » SQL & PL/SQL » Client Tools » I can't compile or execute any procedures anymore. (10.2.0.1)
icon8.gif  I can't compile or execute any procedures anymore. [message #327754] Tue, 17 June 2008 08:23 Go to next message
walter01
Messages: 28
Registered: April 2008
Junior Member
Help needed.

For some reason I can't compile or execute any of my stored procedures from within SQL Developer anymore. Everything has been fine for a month and about half an hour ago I couldn't execute any of my procs anymore. I don't get any compiler messages anymore unless I deliberately put errors in my code. Executing the proc doesn't seem to do anything.
Please advise.

kind regards,

Walter
Re: I can't compile or execute any procedures anymore. [message #327756 is a reply to message #327754] Tue, 17 June 2008 08:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
walter01 wrote on Tue, 17 June 2008 06:23
Help needed.

For some reason I can't compile or execute any of my stored procedures from within SQL Developer anymore. Everything has been fine for a month and about half an hour ago I couldn't execute any of my procs anymore. I don't get any compiler messages anymore unless I deliberately put errors in my code. Executing the proc doesn't seem to do anything.
Please advise.

kind regards,

Walter

Windoze fix is to reboot DB server.
Re: I can't compile or execute any procedures anymore. [message #327758 is a reply to message #327756] Tue, 17 June 2008 08:34 Go to previous messageGo to next message
walter01
Messages: 28
Registered: April 2008
Junior Member
Hi anacedent,

the DB is running on a Linux server.
Re: I can't compile or execute any procedures anymore. [message #327760 is a reply to message #327758] Tue, 17 June 2008 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
walter01 wrote on Tue, 17 June 2008 06:34
Hi anacedent,

the DB is running on a Linux server.


How would anyone but YOU know the OS?

http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as presented in URL above

The fix is still the same.
Re: I can't compile or execute any procedures anymore. [message #327763 is a reply to message #327760] Tue, 17 June 2008 08:51 Go to previous messageGo to next message
walter01
Messages: 28
Registered: April 2008
Junior Member
Thanks Anacedent,

Next time I'll also supply my os version.

Any idea how something like this could have happened ?
Re: I can't compile or execute any procedures anymore. [message #327767 is a reply to message #327763] Tue, 17 June 2008 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
walter01 wrote on Tue, 17 June 2008 06:51
Thanks Anacedent,

Next time I'll also supply my os version.

Any idea how something like this could have happened ?


Let me guess.
Procedure does DML & contains no COMMIT.
Am I correct?
Re: I can't compile or execute any procedures anymore. [message #327779 is a reply to message #327767] Tue, 17 June 2008 09:43 Go to previous messageGo to next message
walter01
Messages: 28
Registered: April 2008
Junior Member
Sorry, You guessed wrong.

I did some testing and for some reason the procedures won't execute from the SQL Developer application anymore. Executing it from Sqlplus works fine.
For now Sqlplus will be my work around and I'll try to get the client software working again.

thanks,

Walter
Re: I can't compile or execute any procedures anymore. [message #327780 is a reply to message #327779] Tue, 17 June 2008 09:52 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
What error exactly you have got while trying to execute?
Re: I can't compile or execute any procedures anymore. [message #327783 is a reply to message #327780] Tue, 17 June 2008 10:05 Go to previous messageGo to next message
walter01
Messages: 28
Registered: April 2008
Junior Member
I got ... nothing.
I press compile, the button blinks once and that's it. No compiler message in the message window. Only when there are errors in my source.

Walter
Re: I can't compile or execute any procedures anymore. [message #327825 is a reply to message #327783] Wed, 18 June 2008 02:24 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What message do you expect?
Is the code in the db changed?

"Nothing is happening" is about the lousiest description of a problem in IT. (and hardly ever true)
Re: I can't compile or execute any procedures anymore. [message #327860 is a reply to message #327825] Wed, 18 June 2008 04:08 Go to previous messageGo to next message
walter01
Messages: 28
Registered: April 2008
Junior Member
Solved.

Frank,

When I compile a procedure the "compiled" message should be shown and when executing the procedure a "Run pl/sql" acknowledgement form should come up before actually running the script. None of these happened.
But after reinstalling the SQL Developer software everything works fine again. I guess the client software "just went wrong".

thanks everyone,

Walter
Re: I can't compile or execute any procedures anymore. [message #329014 is a reply to message #327754] Mon, 23 June 2008 13:40 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
I love how windows gets a bad wrap for stuff like this.

Nice to see the Linux has become more real. Re-install a bad app (hehehe) used to be reserved as a windows fix for any app that started behaving badly.

Soon we will be seeing "just reboot (this or that) to fix it" as a Linux solution. Can't wait.

Kevin
Previous Topic: Is it Hung ?
Next Topic: ORA-12154; TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Sat Dec 10 10:36:10 CST 2016

Total time taken to generate the page: 0.04679 seconds