How to call the procedure inside the trigger

[kaleeswaran]

Hi!
can i call the procedure inside the trigger?....
thank you,
kaleeswaran

[r035198x]

Hi!
can i call the procedure inside the trigger?....
thank you,
kaleeswaran

The short anwer is "yes". Try it and see what happens.

[amitpatel66]

Hi!
can i call the procedure inside the trigger?....
thank you,
kaleeswaran

You can call a procedure from a trigger in a similar way you call them from any other block

[kaleeswaran]

hi!
try to run the following trigger...but it shows error like this:

Access denied; you need the SUPER privilege for this operation
so what should i do?....

my code is:

CREATE TRIGGER `test`.`sample_tri` AFTER INSERT
    ON test.test_one FOR EACH ROW
BEGIN
    insert into cust values(1,'sam');
END;

[amitpatel66]

hi!
try to run the following trigger...but it shows error like this:

Access denied; you need the SUPER privilege for this operation
so what should i do?....

my code is:

CREATE TRIGGER `test`.`sample_tri` AFTER INSERT
ON test.test_one FOR EACH ROW
BEGIN
insert into cust values(1,'sam');
END;

I think you dont have CREATE TRIGGER Privilege to create a new trigger.
You need t oask your DBA To GRANT privileges to you for creating triggers!!

[amitpatel66]

Kaleeswaran,

As a full member now, you should know that we expect your code to be posted in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use the tags in future.

MODERATOR.