Extended Stored Proc Trouble With Srv_paramsetoutput And LOB Types

Hi,

I have written an extended stored proc: xp_DoSomething that can be called from T-SQL:






Code Snippet

declare @txt varchar(max)

exec xp_DoSomething @txt output

select @txt



The proc generates a correct value for @txt, but I can't get the result into the output parameter - the important part of the code is:






Code Snippet

if(FAIL == srv_paramsetoutput(srvproc, 1, dataPtr, len, FALSE))

{

throw OutputParameterDataError();

}



It seems that srv_paramsetoutput function always returns FAIL if type of the output parameter is LOB (varchar(max),nvarchar(max), varbinary(max)). Is there any way to return LOB parameter by an extended procedure?



Any help gratefully received



Thanks,

Va1era