Topic: SQL*Plus and PL/SQL >> Calling Stored Proc from Triggers - Plz help (Urgent)
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Calling Stored Proc from Triggers - Plz help (Urgent) |
| prasad |
Posted: Jun 20, 2008 05:52:20 AM |
Total Post: 35
Joined: Jan, 2007
|
Hi
I want to create AFTER UPDATE trigger on a table, wherein if "filedate" field gets changed, the trigger should get fired.
Following code is throwing error:
CREATE OR REPLACE TRIGGER notify_user
AFTER UPDATE of filedate on <table_name>
for each row
begin
WHEN (new.appl='UCC' and new.stcode='NY' and new.dbflag='UD')
call send_mail
end;
Can somebody please tell me where i have made mistake....?
Thanks in advance. |
|
|
 Vish |
| Posted: Jul 27, 2008 08:07:43 AM |  |
|
Total Post: 100
Joined: Jan, 2007
|
Syntax of creating trigger is follows
CREATE OR REPLACE TRIGGER <TRIGGER NAME>
{BEFORE /AFTER} {INSTER/UPDATE/DELETE} ON <TABLE NAME>
{FOR EACH ROW} U DIDN'T HAVE TO GIVE COLUM. NAME.
DECLARE
BEGIN
END;
in your case i think you wrote wrong systex.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 334 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
