sp_OAMethod

[Martin Lingl]

Hi group,

I have been working with COM objects in T-SQL for some time, but now I face
a problem I cannot solve:

I have an object with a method that takes several input parameters but does
not return anything.

If I proceed to list the input parameters right after the method name (EXEC
sp_OAMethod @object, @method, @param1, @param2, ...) I get an error saying
that the syntax of sp_OAMethod is incorrect, that an output parameter for
the return value is expectod after the method name:
sp_OAMethod usage: ObjPointer int IN, MethodName varchar IN [,
@returnval <any> OUT [, additional IN, OUT, or BOTH params]]

If I add such an output parameter, the call fails blaming me for specifying
an ouput parameter when the method does not return any value:
Error in parameters, or attempt to retrieve a return value from a
method that doesn't supply one.

Does anybody know a solution?

Thanks,
Martin

[Unregistered]

Have you tried passing NULL in as the returnVal at all?