| ORA-00604 Error SQL recursive 1 [message #197774] |
Thu, 12 October 2006 11:17  |
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  |
rleishman
Messages: 3728
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
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
