MySQL Forums
Forum List  »  Triggers

trigger exist or not? interesting create trigger problem
Posted by: ismail arslan
Date: January 19, 2006 05:14AM

hi, i have an interesting problem about creating trigger. let me introduce:

i want to create my trigger like this:

DELIMITER $$

CREATE TRIGGER trg_logisticPapers
AFTER INSERT
ON LogisticServiceContract
FOR EACH ROW
BEGIN
call LogisticPaperSP ( NEW.contractId, NEW.lscId );
END; $$


the procedure that i call works well, also this trigger was working fine in another machine. when i try to execute the script above, i get the error message:

___Trigger already exists. ErrorNr.1359

well, this is not a problem, then i tried this one:

___DROP TRIGGER trg_logisticPapers;

and the error message::

___Trigger does not exist. ErrorNr.1360


and now, what should i do? it exists or not? how can i solve this?



Edited 1 time(s). Last edit at 01/19/2006 05:15AM by ismail arslan.

Options: ReplyQuote


Subject
Views
Written By
Posted
trigger exist or not? interesting create trigger problem
4608
January 19, 2006 05:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.