Stack Overflow
Stack Overflow

Questions tagged [ora-04088]

ORA-04088: Error during execution of trigger

ORA-04088: Error during execution of trigger

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.

9 questions
4
votes
2 answers

mutating, trigger/function may not see it- error during execution of trigger

CREATE OR REPLACE TRIGGER UPDATE_TEST_280510 AFTER insert on TEST_TRNCOMPVISIT declare V_TRNCOMPNO NUMBER(10); CURSOR C1 IS SELECT B.COMPNO FROM TEST_TRNCOMPVISIT A, TEST_TRNCOMPMST B, TEST_MEMMAST C WHERE…
mahesh soni
  • 43
  • 1
  • 3
1
vote
1 answer

What could be the reasons for an Oracle trigger to fail?

First, let me explain shortly how my application is working: The application handles deals, which are stored as an XML document in our database (Oracle 11g). The table that contains these information is defined like that: table T_MYDEALS ( …
Romain Linsolas
  • 79,475
  • 49
  • 202
  • 273
1
vote
3 answers

Trigger errors ORA-04092 ORA-04088

I created a trigger as below: CREATE OR REPLACE TRIGGER trigger_test AFTER INSERT ON trigger_1 FOR EACH ROW DECLARE t_identifier VARCHAR2(10); t_name VARCHAR2(20); BEGIN t_identifier := (:NEW.IDENTIFIER); t_name := (:NEW.NAME); INSERT INTO…
Vijay
  • 65,327
  • 90
  • 227
  • 319
1
vote
3 answers

error trying to make a trigger in oracle

i'm trying to make a TRIGGER in ORACLE using ORACLE SQL DEVELOPER, I would check that the dates entered as start date reservation to reservation date or date of a service charge will be equal to or greater than the current date is inserted in the…
franvergara66
  • 10,524
  • 20
  • 59
  • 101
1
vote
2 answers

oracle trigger after inserting or updating a sales item

I have this table that represents a weak entity and is a typical table for introducing items ordered: insert into ITEM_FORNECIMENTO values (a_orderId,a_prodId,a_prodQtd, a_buyPrice); I want my trigger to update the last column (the total price of…
neverMind
  • 1,757
  • 4
  • 29
  • 41
1
vote
2 answers

Error during trigger execution - ORA-06512 - ORA-04088

I've these tables CELL(CellId, x0, y0, x1, y1, CurrentPhone#, MaxCalls) TELEPHONE(PhoneNo, x, y, PhoneState) STATE_CHANGE(ChangeId, TimeStamp, PhoneNo, x, y, ChangeType) And I've to create this trigger (the trigger is mandatory) Changing the…
user2999664
  • 15
  • 1
  • 1
  • 5
0
votes
1 answer

Error ORA-04088 using triger before UPDATE

I ran into this error. I tried to explore other 04088 topics but I am still not able to fix it. My trigger: CREATE OR REPLACE TRIGGER "TU_INTEGRATIONS" BEFORE UPDATE ON INTEGRATIONS REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE …
vviston
  • 183
  • 1
  • 12
0
votes
0 answers

SQL Developer errors: ORA-06512 and ORA-04088

create or replace TRIGGER TR_T_PR_FARMACO BEFORE INSERT ON T_PR_DIZ_FARMACO FOR EACH ROW BEGIN IF LENGTH(:new.T_PR_DIZ_FARMACO_MINSAN) < 9 THEN RAISE_APPLICATION_ERROR(-20013,'La lunghezza del MINSAN deve essere di 9 cifre'); END IF; END…
EVA PACHETTI
  • 1
0
votes
2 answers

Problem with UTL_FILE.FCOPY in a trigger

I am new to triggers. I created a trigger below: CREATE OR REPLACE TRIGGER ac01_control_trigg AFTER INSERT ON AC01_CONTROL_TEST FOR EACH ROW DECLARE BEGIN IF :NEW.cur_pgm_name = 'LSN' AND :NEW.nxt_pgm_name ='MD' AND :NEW.file_status='RD'…
Vijay
  • 65,327
  • 90
  • 227
  • 319