-
Trigger calling a stored procedure
Hi,
I keep getting an error when compiling this trigger. thanks,
I can run the send mail proc by itself, but from within the trigger I get
Error(12,15): PLS-00103: Encountered the symbol "SEND_MAIL" when expecting one of the following: := . ( @ % ; immediate The symbol ":=" was substituted for "SEND_MAIL" to continue.
code
CREATE OR REPLACE TRIGGER "BU_ENTITY_TEST" AFTER
UPDATE OF "FACILITY_MANAGED_SECURITY_FLAG"
ON "ENTITY_TEST" FOR EACH ROW
DECLARE
BEGIN
IF (:NEW.FACILITY_MANAGED_SECURITY_FLAG = -2) THEN
execute send_mail(msg_to=>'somemail@123.com');
END IF;
END bu_entity_test;
-
found it.
I had to remove the execute.
But now, I get this error.
4/1 PL/SQL: Statement ignored
4/53 PLS-00707: unsupported construct or internal error [2603]
Last edited by kburrows; 10-03-2011 at 03:04 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|