I m facing the issue in altering a table through stored procedure. I m invoking a stored procedure through the connection having Transaction Type as LOCAL_TRANSACTION.
It is returning correct parameters what I m expecting, but the records which should get created in the table on execution of this proc…are not in the table. We dont have any Commit statement in stored proc & we cant do it either.
I tried to use explicit commit services(startTransaction & commitTransaction) also but no luck.