SQL & PL/SQL

Hi All,

the trigger error says: maximum number of recursive SQL levels (50) exceeded.

But i would expect it to say that mutating table error.

As the trigger is trying to insert into the same table on which the trigger is based (referring the same table and it is a row level trigger).

Are the two errors the same.

Code:

CREATE OR REPLACE TRIGGER employee_ins_t1
BEFORE INSERT ON employee FOR EACH ROW
BEGIN INSERT INTO employee (employee_id) VALUES (employee_seq.nextval);
END;

Just wanted to know the diff.
I understand recursion, but in this case it is simply a violation of trigger rule...it is mutating.

Any idea why i am given the other error.
meenakshi