Very Computer

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

Triggers fire for every insert.  Your triggers are recursively firing
themselves!!

Luke

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!