Last post May 08, 2016 02:04 AM by Das.Sandeep
May 06, 2016 09:47 PM|Jahangeer|LINK
i get this error when executing the stored procedure. i insert record into 4 tables and all insert queries execute successfully but at the end of execution of stored procedure i get a conversion error from data type varchar to int.
here is stored procedure that i create
To View Image
and this is the error i get after execution
if all 4 insert queries execute successfully then why is error is coming?
May 07, 2016 03:02 AM|Das.Sandeep|LINK
It looks @school_id_out is coming in parameter as varchar but it is int. Please change to int. or pass in last line as Cast(@school_id_out as int)
May 07, 2016 08:32 AM|Jahangeer|LINK
sandeep let me try and i will let you know
May 07, 2016 09:05 AM|Jahangeer|LINK
i have tried this but not working, can you tell me some other way to do that?
May 07, 2016 10:51 AM|Kulrom|LINK
It's hard to tell what FIELD is causing the issue. I need to have access to the database and check the fields manually in order to help you.
Feel free to contact me via PM if you want
May 08, 2016 02:04 AM|Das.Sandeep|LINK
Could you please let me know, what did you try? Share the syntax and confirm database column type in table?