MySQL Forums
Forum List  »  Stored Procedures

Re: Question about an event in a procedure
Posted by: To bi
Date: January 24, 2012 03:43AM

Now I have tested this code:

CREATE PROCEDURE `editEvent`(ename VARCHAR(50))
BEGIN

DECLARE eparameter VARCHAR(50);

SELECT parameter.wert INTO eparameter
FROM parameter
WHERE parameter.name = ename;


SET @eshedule := CONCAT("ALTER EVENT ",ename," ON SCHEDULE EVERY ",eparameter," STARTS '2012-01-20 10:00:00'");

prepare stmt from @eshedule;
execute stmt;
deallocate prepare stmt;

END;
//


But this will show a mysql problem like
"#1295 - This command is not supported in the prepared statement protocol yet"


Can't anyone help me?

Options: ReplyQuote


Subject
Views
Written By
Posted
1886
January 23, 2012 08:53AM
Re: Question about an event in a procedure
904
January 24, 2012 03:43AM
873
January 25, 2012 02:31AM


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.