How to obtain returned large string with sp_OAMethod?
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01141810
Message ID:
01141810
Views:
51
Hi, I try to call a COM with sp_OACreate,sp_OAMethod etc. in my SP,the problem is how i can get the large string from the method of the COM, - the returned value usually is a XML string, might be greater than varchar(8000). Tks in adv.