stored procedure – Chilkat Tech Notes

January 3, 2025

SQL Server Methods that Return Long Strings

SQL Server Methods that Return Long Strings Some ActiveX methods return strings that are too long for local string variables. How can these be returned to the calling stored procedure? Answer The Chilkat Global object has a property named KeepStringResult which can be set to 1. (The default value is 0.) When set to 1, then each method that returns […]

General 0 1 min read

May 27, 2022

SQL sp_OAMethod String Length Return Value Limitations

The sp_OAMethod function is used to call ActiveX methods in SQL stored procedures. If the ActiveX method returns a string, there is a limit imposed by sp_OAMethod on the size of the string that can be returned. (Perhaps it is 4000 chars?) This blog post describes a way to workaround this limitation. An example of a method call that is […]

SQL Server 0 2 min read

SQL Server Methods that Return Long Strings

SQL sp_OAMethod String Length Return Value Limitations

Blogroll

Tags