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 330,267 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 3,515 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!

•

FAQ | Community Rules | Welcome Guide

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 144 | Replies: 2 | Solved

•

Join Date: Apr 2008

Posts: 33

Reputation: veledrom is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

veledrom

Offline

Light Poster

Trigger error

9 Days Ago

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,551

Reputation: peter_budo will become famous soon enough

Rep Power: 8

Solved Threads: 149

peter_budo peter_budo is offline

Offline

Posting Virtuoso

Re: Trigger error

4 Days Ago

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.