Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00604 Error SQL recursive 1
ORA-00604 Error SQL recursive 1 [message #197774] Thu, 12 October 2006 11:17 Go to next message
tovohery
Messages: 5
Registered: September 2006
Junior Member
Hi all,
after running

create table x as select * from y;
I receive the following error message

ORA-00604: error occurred at recursive SQL level 1
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_CDC_PUBLISH" has errors
ORA-06508: PL/SQL :Program not found
ORA-06512: at line 3

What could be the issue? Any help?
Re: ORA-00604 Error SQL recursive 1 [message #197842 is a reply to message #197774] Thu, 12 October 2006 20:15 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
ORA-00604 means look at the next message.
ORA-04068: existing state of packages has been discarded 


That message means that you have previously used the procedure/function in this session (so you have a cached copy), but it has been rebuilt since then, so you have to reload it. You can do that just by running it again.

ORA-04063: package body "SYS.DBMS_CDC_PUBLISH" has errors 
This one is the kicker though. The package has a syntax error in it. When the package last compiled, it should have returned an error. Compile it again, find and fix the error, and re-run.

Ross Leishman
Previous Topic: return multiple row in function
Next Topic: how to use oracles IRR function
Goto Forum:
  


Current Time: Thu Dec 08 19:53:06 CST 2016

Total time taken to generate the page: 0.14873 seconds