ORA-04088: error during execution of trigger 'string.string' tips Oracle Error Tips by Stephanie F.

 

The Oracle docs note this on the ora-04088 error:

A user encounters ORA-06512 and ORA-04088 while attempting to create a custom trigger as follows:

1 CREATE OR REPLACE TRIGGER hari_dt
2 BEFORE INSERT
3 ON
4 hari
5 FOR EACH ROW
6 DECLARE
7 v_name varchar2(20);
8 BEGIN
9 v_name :=upper(:new.name);
10 insert into hari values(v_name);
11* end;
12 /

Trigger created.

SQL> insert into hari values('harindar');
insert into hari values('harindar')
*
ERROR at line 1:
ORA-00036: Maximum number of recursive sql levels (50) exceeded
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of trigger 'BUSMASTERQ.HARI_DT'
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of trigger 'BUSMASTERQ.HARI_DT'
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of trigger 'BUSMASTERQ.HARI_DT'
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of trigger 'BUSMASTERQ.HARI_DT'
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of trigger 'BUSMASTERQ.HARI_DT'
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of trigger 'BUSMASTERQ.HARI_DT'
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of trigger 'BUSMASTERQ.HARI_DT'
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of trigger 'BUSMASTERQ.HARI_DT'
ORA-06512: at "BUSMASTERQ.HARI_DT", line 5
ORA-04088: error during execution of triggercan

The problem concerning ORA-04088 is resolved when the user is informed that

The problem lies with the fact that you are inserting a row in the trigger which has to fire before insert, the trigger is causing itself to fire over and over and over and getting stuck in a loop.

Remove line which includes the insert.

---

A link that you might find useful in resolving ORA-04088, concerning expression datatypes, is:

http://www.rampant-books.com/10g_85.htm