cursor Problem

From: Dennis <echome_at_ms16.hinet.net>
Date: 28 Jan 2000 00:39:10 GMT
Message-ID: <86qofe$sfo$1@news.seed.net.tw>

Dear all,

        There is a cursor problems, hope you can provide ideas to help me. The following is the statements that I executed in SQLPlus:

SQL> create table test (c1 varchar(20)); SQL> create or replace trigger before_stat

          before insert on test
          begin
            insert into test
           values(to_char(sysdate,'MI:SS'));
          end;
SQL> create or replace trigger after_stat
          after insert on test
          begin
            insert into test
            values(to_char(sysdate,'MI:SS'));
          end;

SQL> insert into test values(to_char(sysdate,'MI:SS'));

        The last statement failed, and Oracle responsed "ORA-01000: the maximum open cursors execeeded." Why? The init. parameter of OPEN_CURSORS is 50. It is supposed not to execeed. I tried these on Oracle 8.0.3.0.6 for Novell and Oracle 7.3.2.2.1 for NT. Both of them got the same result. Thanks for your ideas in advance!

Best Regards

Dennis Received on Thu Jan 27 2000 - 18:39:10 CST