00604 Error Occurred At Recursive
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company ora 00604 error occurred at recursive sql level 3 Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
Ora-00604 Error Occurred At Recursive Sql Level 1 Ora-01722 Invalid Number
Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers,
Ora-00604 Error Occurred At Recursive Sql Level 1 Ora-01003 No Statement Parsed
just like you, helping each other. Join them; it only takes a minute: Sign up How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1 up vote 1 down vote favorite 1 When
Ora-00604 Error Occurred At Recursive Sql Level S
I'm trying to drop table then I'm getting error SQL Error: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows 00604. 00000 - "error occurred at recursive SQL level %s" *Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables). *Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact ora-00604 error occurred at recursive sql level 1 ora-01031 insufficient privileges Oracle Support. oracle oracle11g drop-table share|improve this question edited May 27 '15 at 10:04 asked May 27 '15 at 9:15 Ravi 7,5962160100 did you try purge dba_recyclebin? It looks like you're hitting some Oracle bug. –ibre5041 May 27 '15 at 9:21 It seems like I can not run purge dba_recyclebin. –Ravi May 27 '15 at 9:23 purge recyclebin if you don't have DBA role –Rene May 27 '15 at 9:24 That's what I tried and I mentioned on my post –Ravi May 27 '15 at 9:28 1 But if the drop errors only started after the purge errors, they are probably related. Did you try to re-drop a BIN$ table before the issue began? You need to contact Oracle support anyway, I think, or at least your DBA who may be able to fix it or may have to contact support. –Alex Poole May 27 '15 at 10:15 | show 4 more comments 2 Answers 2 active oldest votes up vote 0 down vote One possible explanation is a database trigger that fires for each DROP TABLE statement. To find the trigger, query the _TRIGGERS dictionary views: select * from all_triggers where trigger_type in ('AFTER EVENT', 'BEFORE EVENT') disable any suspicious trigger with alter trigger
01, 2013 - 7:13 pm UTC Category: Database – Version: 9.0.1.0.0 Latest Followup You Asked Hi, I have the ora-00604 error occurred at recursive sql level 1 in oracle following problem: SQL> select * from t; select * from t ora-00604 error occurred at recursive sql level 2 * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-04092: cannot COMMIT in ora-604 error occurred at recursive a trigger ORA-06512: at line 12 ORA-00942: table or view does not exist And table `t' does not exist. But this happens no matter what user I http://stackoverflow.com/questions/30478070/how-to-solve-sql-error-ora-00604-error-occurred-at-recursive-sql-level-1 am, no matter what I do but only if there are errors (assuming that it would normally give only the last error). I was looking for the trigger that might do commit but there is no single one in any schemas in our database. What does this ORA-00604 mean? Does it have something to https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:4018285967344 do with recursive SQL queries? Is this some kind of internal problem? How can I get rid of it? Thanx in advance, Piotr and we said... someone created an "after servererror" trigger and is committing in it. consider: ops$tkyte@ORA9I.WORLD> drop user a cascade; User dropped. ops$tkyte@ORA9I.WORLD> ops$tkyte@ORA9I.WORLD> grant create session to a identified by a; Grant succeeded. ops$tkyte@ORA9I.WORLD> ops$tkyte@ORA9I.WORLD> @connect a/a ops$tkyte@ORA9I.WORLD> set termout off a@ORA9I.WORLD> REM GET afiedt.buf NOLIST a@ORA9I.WORLD> set termout on a@ORA9I.WORLD> select * from t; select * from t * ERROR at line 1: ORA-00942: table or view does not exist a@ORA9I.WORLD> a@ORA9I.WORLD> @connect / a@ORA9I.WORLD> set termout off ops$tkyte@ORA9I.WORLD> REM GET afiedt.buf NOLIST ops$tkyte@ORA9I.WORLD> set termout on ops$tkyte@ORA9I.WORLD> drop table log; Table dropped. ops$tkyte@ORA9I.WORLD> create table log( msg varchar2(255) ); Table created. ops$tkyte@ORA9I.WORLD> ops$tkyte@ORA9I.WORLD> create or replace trigger error_trigger 2 after servererror on database 3 begin 4 insert into log values ( 'hi' ); 5 commit; 6 end; 7 / Trigger created. ops$tkyte@ORA9I.WORLD> ops$tkyte@ORA9I.WORLD> @connect a/a o
Topic Database design Database Admin View All Cloud infrastructure Availability Backup and recovery Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle http://searchoracle.techtarget.com/answer/Getting-ORA-00604-error-when-connecting-to-database-user security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business performance management Implementing and upgrading http://dba.stackexchange.com/questions/138635/ora-00604-error-occurred-at-recursive-sql-level-string-hides-the-real-error Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality error occurred Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open error occurred at Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Commun
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ORA-00604 (error occurred at recursive SQL level string) hides the real error up vote 1 down vote favorite My multithreaded program inserts records into a table. ORA-00001 (unique constraint violated) should not be fatal. But prod environment has a complex configuration with read-only schema and the table for my inserts being a synonym for a remote table, which is partitioned. Inserts work fine until PK violated, then instead of SQLCODE=-1 I'm getting SQLCODE=-614 and a multiline description: insert into CDRGPRSIMEI (ms_id,startdatetime,calltype,imei) values (:b0,to_date(:b1,'YYYYMMDDHH24MISS'),:b2,:b3) ^ ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access ORA-06512: at line 120 ORA-16000: database open for read-only access ORA-00001: unique constraint (CDRIMEI.PK_CDRGPRSIMEI) violated ORA-02063: preceding line from CDRIMEI_PRIM_PPB What can cause this? Is it always related to triggers? If DBA can't fix it on prod, how to reproduce this on my test env. (e.g. by writing a special trigger)? trigger oracle-12c database-link share|improve this question asked May 16 at 13:58 basin 1436 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Browse other questions tagged trigger or