MySQL

Calling a procedure from Trigger

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2008

Posts: 9

Reputation: bvssam is an unknown quantity at this point

Solved Threads: 0

bvssam

Offline

Newbie Poster

Calling a procedure from Trigger

Dec 31st, 2008

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.

 Help with Code Tags 
 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.

•

Join Date: Jul 2007

Posts: 1,175

Reputation: stephen84s is a glorious beacon of light

Solved Threads: 125

stephen84s stephen84s is offline

Offline

Veteran Poster

Re: Calling a procedure from Trigger

Jan 1st, 2009

What is the Error that MySQl threw at you ??

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

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."

"How to ask questions the smart way ?"