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?
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
856
January 24, 2012 09:37AM
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.