After migration Oracle database into SQL Server 2016 facing problem in VB 6.0 application

[Ifor]

You probably need to:

SET XACT_ABORT ON;

at the start of the SQL Server stored procedure.