Home » RDBMS Server » Server Administration » very strang errors from a very simple trigger
very strang errors from a very simple trigger [message #370900] Fri, 03 March 2000 19:04 Go to next message
Rick
Messages: 49
Registered: March 2000
Member
pls see below and help, thanks.
-------------from here--------------------------

SQL> @ /oracle/crtrigger.sql
12 /

Trigger created.

SQL> host cat /oracle/crtrigger.sql;

SQL> desc test2;
Name Null? Type
------------------------------- -------- ----
NAME VARCHAR2(10)

SQL> select name, value from v$parameter where name = 'open_cursors';

NAME
----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
open_cursors
50


SQL> insert into test2 values ('');
insert into test2 values ('')
*
ERROR at line 1:
ORA-01000: maximum open cursors exceeded
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: error during execution of trigger 'RICK.CHECK_NAME'
ORA-06512: at "RICK.CHECK_NAME", line 5
ORA-04088: erro
Re: very strang errors from a very simple trigger [message #370961 is a reply to message #370900] Tue, 14 March 2000 13:52 Go to previous messageGo to next message
Roshan D'Souza
Messages: 8
Registered: March 2000
Junior Member
Rick,

I had the same problem. The reason to this is not simple. There could be many causes.

Firstly you need to check whether you had closed the cursor within the trigger if you had create one.
Secondly it may be so that the error is not due to the trigger. It may be due to other PL/SQL code which is running in the background and has many open cursors.
Thirdly it may also be due to procedures which have ended with a open cursor. Thats why Oracle recommends to always close the cursor after its use. You get strange errors due to this.

Best thing would be to look into the Dynamic tables (V$ tables) to find out the open cursors hogging the resource.

I hope my reply would be any help to you.
Re: very strang errors from a very simple trigger [message #370962 is a reply to message #370900] Tue, 14 March 2000 13:54 Go to previous message
Roshan D'Souza
Messages: 8
Registered: March 2000
Junior Member
Rick,

I had the same problem. The reason to this is not simple. There could be many causes.

Firstly you need to check whether you had closed the cursor within the trigger if you had create one.
Secondly it may be so that the error is not due to the trigger. It may be due to other PL/SQL code which is running in the background and has many open cursors.
Thirdly it may also be due to procedures which have ended with a open cursor. Thats why Oracle recommends to always close the cursor after its use. You get strange errors due to this.

Best thing would be to look into the Dynamic tables (V$ tables) to find out the open cursors hogging the resource.

I hope my reply would be of some help to you.
Previous Topic: Using select statement find the rank...
Next Topic: Data Types & Functions in Oracle 7.3.4 Server
Goto Forum:
  


Current Time: Wed Oct 21 11:54:33 CDT 2020