Recent Posts

Caution: Greetings to all visitors. The site is working in short. Links Please skip the link to view any topic and thank you for visiting
header ads

MYSQL out parameter

Iḿ very new to sql; I wrote the following stored procedure but I do not receive the out parameter with the correct result (allways null).
...................
CREATE DEFINER=`myDB`@`localhost` PROCEDURE `testSP`(in _SN varchar(20), in _ProdLine int, out Result tinyint)
BEGIN
Declare exit handler for sqlexception select Result = 1;

insert into testTB (DateTime, SN, ProdLine) values (Current_Timestamp(), _SN, _ProdLine);
select Result = 0;
END
..............
Which error am I doing ?...

MYSQL out parameter

from Databases https://ift.tt/2K7nHn9
via IFTTT

Post a Comment

0 Comments