TEST 1 : How to insert each value as a string variable
sql => “call SP_INSERT_PROCESS_RUN_INFO('” + str_IN_PROCESS_ID + “', '” + str_IN_PROCESS_RUN_ID + “', '” + str_IN_PROCESS_RUN_STATE + “', '” + str_IN_ERRMSG + “');”
TEST 2 : How to insert by declaring a variable in Parameters among the properties of ExecuteNonQuery
sql => “call SP_INSERT_PROCESS_RUN_INFO;”
for mssql => “SP_INSERT_PROCESS_RUN_INFO”
Among the above two methods, why does TEST 2 fail?
This method worked in mssql but fails in mariadb.
I wonder why it is not possible to create a variable using the Parameters property.