Calling a procedure from Trigger

Expand Post »

Hi Group,

I have a small Query regarding calling a procedure from a trigger
please go through the following and please let me knwo if any thing wrong happened.

sql Syntax (Toggle Plain Text)
DELIMITER $$
 
DROP PROCEDURE IF EXISTS `test`.`sample` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sample`()
BEGIN
  INSERT INTO test.out(num,message) SELECT num,name FROM test.IN,hotel
  WHERE IN.message = hotel.pin;
END $$
 
DELIMITER ;
 
 
 CREATE trigger `pull` after INSERT on `test.IN`
 for each row
 BEGIN
 CALL sample();
DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`sample` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sample`()
BEGIN
  insert into test.out(num,message) select num,name from test.in,hotel
  where in.message = hotel.pin;
END $$

DELIMITER ;


 create trigger `pull` after insert on `test.in`
 for each row
 begin
 call sample();

When I tried to create a trigger to call the procedure it is throwing error.

so please solve my small Query

Thanks in advance

Last edited by peter_budo; Jan 6th, 2009 at 9:27 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32) in MS SQL

bvssam

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Oct 2008

Permalink

Jan 1st, 2009

Re: Calling a procedure from Trigger

What is the Error that MySQl threw at you ??

Also did you remember to put the "END" at the end of the Trigger.

stephen84s

Featured Poster

Reputation Points: 653

Solved Threads: 151

Nearly a Posting Virtuoso

Offline

1,316 posts
since Jul 2007

Permalink

Jan 2nd, 2009

Re: Calling a procedure from Trigger

Yes I did,

I put the END and tried but it is same as before.

bvssam

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Union Site Search with Relevance

Next Thread in MySQL Forum Timeline: MySQL Cluster 101 Webcast

DaniWeb Message

Cancel Changes

User Name
Password