Multiple Row Insert + Dynamic SQL

[mahi22]

Hi All,

I am trying to insert multiple rows using a single insert statement in a stored procedure. The code i am using is like -

set s1 = 'Insert into table_name(x,y) values (?,?),(?,?)';
prepare s2 from s1;
execute s2 using var1,var2,var3,var4;

I am getting an error.

Any advise appreciated.

Thanks.

 

[MarcLodge]

What's the error you are getting?!