Trigger error

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 374,006 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,766 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 680 | Replies: 2 | Solved

•

Join Date: Apr 2008

Posts: 95

Reputation: veledrom is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

veledrom

Offline

Junior Poster in Training

Trigger error

May 4th, 2008

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

Help with Code Tags

(Toggle Plain Text)

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;

•

Join Date: Dec 2004

Location: London or Slovakia

Posts: 1,907

Reputation: peter_budo has a spectacular aura about

Rep Power: 9

Solved Threads: 216

peter_budo peter_budo is offline

Offline

Posting Virtuoso

Re: Trigger error

May 9th, 2008

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

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.