MySQL Forums
Forum List  »  Stored Procedures

Code in triggers/Stored Procedures
Posted by: Frank Picone
Date: September 23, 2011 10:49AM

Hi all,

Is it possible to use PREPARE statements in Triggers / stored procedures? If so, is it version specific?

More info:

I'm attempting to migrate an audit trigger that goes through the IMFORMATION_SCHEMA tables to check all the fields in a table during Inserts/Updates/Deletes.

I get "Dynamic SQL is not allowed in stored function or trigger)"

Thanks in advance.
FJP

Options: ReplyQuote


Subject
Views
Written By
Posted
Code in triggers/Stored Procedures
2558
September 23, 2011 10:49AM
1026
September 23, 2011 01:20PM
1065
September 23, 2011 01:46PM
1057
September 23, 2011 03:47PM
1144
September 23, 2011 04:09PM
989
September 23, 2011 06:09PM


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.