Problem: Consuming web methods into Transactions

[nich05]

Hi,

I have a problem when I consume a web method into a stored procedure when that has involved into a transaction.

The problem is because the stored procedure execution stop in the select with error 15207 (that is ok), but with severity 20.

When I did the same without a transaction works fine, but unfortunately that is not what I need to do.

My Sybase is 12.5.2, I configure DTM, XML and Web Services. The stored procedure is as follow:

drop procedure dbo.sp_ws_sample
go
CREATE PROCEDURE dbo.sp_ws_sample
(@param varchar(100))
AS
BEGIN
DECLARE @outxml VARCHAR(4096)
DECLARE @inxml VARCHAR(4096)

set transactional_rpc off
PRINT 'before'
SELECT @inxml = '<Pago xmlns="EAICupos"><!--Optional:--><strRim>string</strRim><strTipoId>string</strTipoId><strIdCliente>string</strIdCliente><strNumOperacion>string</strNumOperacion><strCodigoProducto>string</strCodigoProducto><strCodigoSubProducto>string</strCodigoSubProducto><numTipoPlazo>3</numTipoPlazo><strPlazo>string</strPlazo><numValorOperacion>1000.00</numValorOperacion><numTipoPago>1</numTipoPago><numAplCodigo>' + @param + '</numAplCodigo><strTrId>string</strTrId></Pago>'
SELECT @outxml = CONVERT(VARCHAR(4096), outxml)
FROM Pago
WHERE _inxml = @inxml
PRINT 'after'

insert into testfondo1 (fecha, valor) values (GETDATE(), 'aaaaa')

if @outxml is NULL
BEGIN
PRINT 'no SERVER'
END
ELSE
PRINT @outxml

END
go

I tested like:

begin tran
exec sp_ws_sample "a"
commit tran


I thanks any help.