MySQL StoredProcedure
Posted: Tue 22 Nov 2011 12:19
I have a SP on MySQL-Server
When trying to access this via TUniStoredProc i will get an error during runtime. A quick check inside the IDE works fine.
SQL.Text in TUniStoredProc (auto-generated by TUniStoredProc)
And thats the Exception at Runtime:
So what's the difference between Execute in DesignTime and RunTime?
Code: Select all
CREATE DEFINER = `root`@`%` PROCEDURE `NewProc`(OUT ID varchar(36))
BEGIN
#Routine body goes here...
SET ID = UUID();
END;SQL.Text in TUniStoredProc (auto-generated by TUniStoredProc)
Code: Select all
CALL GetUUID(@ID); SELECT @ID AS '@ID'Code: Select all
EUniError:
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT @ID AS '@ID'' at line 1