could not able to execute the mysql stored procedure using OTL in C++ . I can able to run the procedure directly from mysql and can retried the table data which is inserted through the stored procedure. But The same thing when I am doing through the C++ code using OTL , it executes successfully , but when I am trying to see data in mysql database it gives NO results. I am wondering how can it be possible. // call the stored procedure to insert data odbc:tl_cursor::direct_exec (dbMySQL, "CREATE PROCEDURE test.Proc_CreateInsertDataRowC(strTagIDData MEDIUMTEXT,iRowCnt INT) " "BEGIN " ----------------- --------------- ---------------- -------------- "END IF; " "END " ); // create stored procedure odbc:tl_stream o(1, // buffer size should be equal to 1 in case of stored procedure call "{call test.Proc_CreateInsertDataRowC(" " :A<char[5000],in>, " " :B<int,in> " ")}", // stored procedure call dbMySQL // connect object ); o.set_commit(0); // set stream auto-commit off since // the stream does not generate transaction o << strRow.c_str() << iRowCount; // assigning :A = strRow.c_str() and :B = iRowCount o.set_commit(1); dbMySQL.commit();