STore procedure truncate double
Hi,
I can run Insert statment with srings without problem.
But I have an error when running stored procedure with the same insert stamtement:call outdialque.readPin('12489789145', '12456', 'sarmid') Error Code: 1292. Truncated incorrect DOUBLE value: '}'
This sp:
CREATE DEFINER=`root`@`localhost` PROCEDURE `readPin`(IN ivrPhone VARCHAR(100) , IN ivrPin VARCHAR(20), IN ivrSite VARCHAR(20))
BEGIN
insert into callque (phonenumber, phonenumberprefix, activatetime,
TimeStart_Mon,TimeStop_Mon,TimeStart_Tue,TimeStop_Tue,TimeStart_Wed,TimeStop_Wed,
TimeStart_Thu ,TimeStop_Thu ,TimeStart_Fri,TimeStop_Fri,
TimeStart_Sat,TimeStop_Sat,TimeStart_Sun,TimeStop_Sun,
campaignname, priority, onanswerlive,
onanswermachine, onnotanswered, onretriesexhausted, answertimeout, retriesleft,
retriesdelay, rv, calloptions, escalationcalls)
values(CAST(ivrPhone as CHAR), '9', curdate(),
1,2359,1,2359,1,2359,1,2359,1,2359,1,2359,1,2359,
'MyHealthPin', 1,
'C:\\Program Files (x86)\\VoiceGuide\\Scripts\\ReadPin\\IvrPin.vgs',
'C:\\Program Files (x86)\\VoiceGuide\\Scripts\\ReadPin\\IvrPin.vgs',
'', '', 60, 1, 10,
'[ivrPhone]{'+CAST(ivrPhone as CHAR)+'}[IvrPin]{'+CAST(ivrPin as CHAR)+'}[IvrSite]{'+CAST(ivrSite as CHAR)+'}', '', '');
END
I added cast with the hope it will help but resuts is the same.
Thank you!