在存储过程中,我正在使用以下语句。但是当我运行存储过程时,它会抛出分布式事务错误。
Declare @res int
Declare @mes as varchar(100)
DECLARE @Result TABLE (
result INT,
mesage VARCHAR(100))
Insert @Result (result, mesage)
Exec [MySpeNet].[dbo].[GetMemberShipStatus]'3319994'
select @res = result, @mes = mesage from @Result
异常:
Msg 7391, Level 16, State 2, Procedure GetMemberShipStatus, Line 19
The operation could not be performed because OLE DB provider "OraOLEDB.Oracle"
for linked server "ASPQA" was unable to begin a distributed transaction.
还有其他方法可以存储结果和信息,而不必创建临时表吗?