Trigger calling a stored procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Trigger calling a stored procedure

  1. #1
    Join Date
    Nov 2000
    Posts
    172

    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;

  2. #2
    Join Date
    Nov 2000
    Posts
    172
    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
  •  



Click Here to Expand Forum to Full Width