Ora-00604 Error Occurred At Recursive Sql Level Connect
Contents |
01, 2013 - 7:13 pm UTC Category: Database � Version: 9.0.1.0.0 Whilst you are here, check out some content from the AskTom team: 12.2 Helps You Manage Persistent Code Base w/New Deprecate Pragma Latest Followup You Asked
Ora 00604 Solution
Hi, I have the following problem: SQL> select * from t; select * from t ora-00604 error occurred at recursive sql level 3 * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-04092: cannot COMMIT in a trigger ORA-06512: at ora-01882 line 12 ORA-00942: table or view does not exist And table `t' does not exist. But this happens no matter what user I am, no matter what I do but only if there are errors (assuming
Ora-00604: Error Occurred At Recursive Sql Level 1 Ora-00942: Table Or View Does Not Exist
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 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
Ora 00604 Oracle Sql Developer
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 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-00604: error occurred at recursive SQL level 1 ORA-04092: cannot COMMIT in a trigger ORA-06512: at line 3 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> select owner, trigger_name 2 from dba_triggers 3 where trigger_type = 'AFTER EVENT'; OWNER TRIGGER_NAME ------------------------------ ----------------
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 ora-16000 tuning Oracle security Oracle DBA tools Error messages MySQL
Ora-01003: No Statement Parsed
database Real Application Clusters (RAC) Applications View All Enterprise and business performance management Implementing ora-38301 and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:4018285967344 intelligence) Data quality 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 http://searchoracle.techtarget.com/answer/Getting-ORA-00604-error-when-connecting-to-database-user All BPEL in Oracle Open 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 Pr
Oct 26, 2013 2:14 PM by Robert Morton ORA-00604: error occurred at recursive SQL level 1 because of tableau temp tables Praveen N Oct 23, 2013 8:55 AM Hi,I am using custom sql (a simple left outer join) to query oracle db https://community.tableau.com/thread/134804 and it is a ready only DB.I am able execute query on sql developer. But https://forums.netiq.com/archive/index.php/t-51057.html when I use the same through tableau, tableau wrappers my query with some customization and creating some temp tables I guess. And finally when it runs the query, I get “Oracle database error 604: ORA-00604: error occurred at recursive SQL level 1: ORA-16000: database open for read-only access" Does this mean when creating a data connection in Tableau, I have error occurred to use an account which has write access to the source database?I don't think to just ready the data, we need write access just because tableau runs some temp queries.Am I missing anything? How do I resolve this error?Any help on this is highly appreciated. Thanks in advance. I have the same question Show 0 Likes(0) 5855Views Categories: Data Sources & Connections, Queries & Performance Tags: none (add) This content has been marked as error occurred at final. Show 3 replies 1. Re: ORA-00604: error occurred at recursive SQL level 1 because of tableau temp tables Robert Sutter Oct 23, 2013 9:06 AM (in response to Praveen N) Do you have fields added to context? If so, Tableau will attempt to create a temp table for speedy provisioning of data. Like Show 0 Likes(0) Actions 2. Re: ORA-00604: error occurred at recursive SQL level 1 because of tableau temp tables Praveen N Oct 23, 2013 7:55 PM (in response to Robert Sutter) No.I haven't added to context. Like Show 0 Likes(0) Actions 3. Re: ORA-00604: error occurred at recursive SQL level 1 because of tableau temp tables Robert Morton Oct 26, 2013 2:14 PM (in response to Praveen N) Hi Praveen,If your Oracle system does not allow writing -- even to a temporary table -- then you should change your user permissions on the database to revoke temp table creation privileges. This will ensure that Tableau does not attempt to utilize temporary tables as a means of accelerating queries. You may find that performance suffers when compared to a database that is not read-only, but you may have no alternative to have the functionality you desire.-Robert Like Show 0 Likes(0) Actions Go to original post Actions Remove from profile Feature on your profile More Like This Retrieving data ...
to the DB ronaldteng10-Jun-2014, 04:02Hi All, I'm currently experiencing a connectivity issue whereby the Oracle driver is unable to connect to the DB. The error that I got is: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: invalid or unknown NLS parameter value specified Some information on the DB is as below: Oracle DB Version: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production NLS_LANGUAGE: AMERICAN NLS_TERRITORY: AMERICA NLS_CHARACTERSET: US7ASCII The driver trace is as below: [06/10/14 10:54:25.789]:ORACLE_TO_IDV-IDV PT:Connecting to database... [06/10/14 10:54:25.790]:ORACLE_TO_IDV-IDV PT:BEGIN Open connection 'dedicated0'. [06/10/14 10:54:25.791]:ORACLE_TO_IDV-IDV PT: BEGIN Instantiate connection. [06/10/14 10:54:25.792]:ORACLE_TO_IDV-IDV PT: CALLING DriverManager.getConnection(String, String, String) [06/10/14 10:54:25.794]:ORACLE_TO_IDV-IDV PT: WITH PARAM 1: jdbc:oracle:thin:@192.168.1.1:1521:HRMSDEVT [06/10/14 10:54:25.796]:ORACLE_TO_IDV-IDV PT: WITH PARAM 2: IDM [06/10/14 10:54:25.797]:ORACLE_TO_IDV-IDV PT: WITH PARAM 3: [06/10/14 10:54:25.855]:ORACLE_TO_IDV-IDV PT:END Open connection. [06/10/14 10:54:25.856]:ORACLE_TO_IDV-IDV PT:BEGIN Close connection 'dedicated0'. [06/10/14 10:54:25.857]:ORACLE_TO_IDV-IDV PT: Connection implementation already closed. [06/10/14 10:54:25.859]:ORACLE_TO_IDV-IDV PT:END Close connection. [06/10/14 10:54:25.860]:ORACLE_TO_IDV-IDV PT:Receiving DOM document from application. [06/10/14 10:54:25.862]:ORACLE_TO_IDV-IDV PT: