Trigger error
 

Hi,
Where is the mistake? It doesn't work. thanks

CREATE OR REPLACE TRIGGER A_ACCOUNT_EKLEME

BEFORE INSERT ON A_SIPARIS



CURSOR CURSOR_TARIH IS 

SELECT TARIH FROM A_ACCOUNT where TARIH = SYSDATE;



FOR EACH ROW

BEGIN

    

    IF CURSOR_TARIH%NOTFOUND THEN

      INSERT INTO A_ACCOUNT (TARIH, PRICE) VALUES (SYSDATE, '1');

    END IF;

END;

Re: Trigger error
 

You marked this post as solved. Did you find solution? Would you mind to share it with otheres?

Re: Trigger error
 

I just changed the logic of my project. Therefore, i don't use it.