creating triggers via perl script
I create a table dynamically in a perl script. I'd also like to create a trigger at the same time for that table...
my $createTableQuery="CREATE TABLE EventEngineRule".$rule_id." (EventID bigint(1) unsigned NOT NULL, TimeStamp datetime NOT NULL) ENGINE=Memory";
my $dbCreateTrigger="DELIMITER | CREATE TRIGGER CheckForAlert After INSERT ON EventEngineRule".$rule_id." FOR EACH ROW DO CALL CheckRuleAll(".$rule_id."); | DELIMITER ;";
Any idea how to accomplish this?
Subject
Written By
Posted
creating triggers via perl script
November 16, 2006 10:33AM
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.