| very strang errors from a very simple trigger [message #370900] |
Fri, 03 March 2000 19:04  |
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
