运行环境win7 (64bit) (同时已经下载安装了SoapToolkit30),trigger编译正常但是运行的时候就会提示错误无法运行,错误信息如下:
error:0x80042725
source:ODSOLE Extended Procedure
description:sp_OAMethod 用法: ObjPointer int IN, MethodName varchar IN [, @returnval OUT [, additional IN, OUT, or BOTH params]]
helpfile:NULL
HelpID:0
以下是具体的触发器sql内容(webservice接口经过测试没有问题)
CREATE TRIGGER [dbo].[log_trigger] ON [dbo].[log]
AFTER INSERT,UPDATE
AS
DECLARE @object int
DECLARE @outParam varchar
DECLARE @inParam varchar
DECLARE @hr int
EXEC @hr = sp_OACreate 'MSSOAP.SoapClient', @object OUT
EXEC @hr = sp_OAMethod @object, 'mssoapinit', null, 'http://localhost:8080/services/baseStationFlow?wsdl', 'baseStationFlow'
EXEC @hr = sp_OAMethod @object, 'baseStationFlow', @outParam OUT, @inParam
IF @hr <> 0
BEGIN
insert into log_test (id,code) values (2,'test');
EXEC sp_OAGetErrorInfo @object
set @outParam = @object
END
EXEC @hr = sp_OADestroy @object