in the SBO_SP_TransactionNotification, updating an item master data, I need to execute a check via PL-SQL select statement to a remote db server via Linked Server.
I use the following command:
EXEC sp_executesql @dynamicsql, N'@ResultCountOut INT OUT', @ResultCountOut=@ResultCount OUT
but I have the following error:
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server
"REMOTE_SAP_CENTRAL" was unable to begin a distributed transaction. 'Company Info' (CINF) (CINF)
I already tried to enable "allow inbound" and "allow outbound" in the MSDTC Windows Service
and to use the SELECT ... FROM OPENQUERY(<linked server>, @sqlstatement) ...
but the issue is not solved.
Please, can someone give me a solution to execute a remote query into the SBO_SP_TransactionNotification?