Large Objects as Stored Procedure Parameters

Open Client and Open Server 15.7 support using text, unitext, and image as input parameters to stored procedures and as parameters to dynamic SQL statements.

Two connection capabilities have been added to facilitate login negotiation regarding the use of this feature:

CS_RPCPARAM_LOB – client applications send this request capability to the server to determine whether large object (LOB) datatypes can be used as input parameters to stored procedures. The server clears this capability bit in the initial login negotiation when it cannot support the feature, and an error occurs when you attempt to send LOB parameters to such a server.
CS_RPCPARAM_NOLOB – client applications send this response capability to request the server to withhold sending LOB data as parameters. This capability is turned on by default.

Send Small Amounts of LOB Data as Parameters
Sending a small amount of LOB data as an input parameter to stored procedures or as a parameter to a prepared SQL statement is the same as sending non-LOB parameters.
Send Large Amounts of LOB Data as Parameters
Large amounts of LOB data is sent in streams to the server to better manage resources. Use ct_send_data() in a loop to send data to the server in chunks.
Retrieve LOB Parameters in Open Server
Retrieve the complete LOB parameter data at once using srv_xferdata or in chunks using the new srv_get_data routine.
srv_get_data
Reads a text, unitext or image parameter stream from a client, in chunks.

Parent topic: Open Client 15.7 and Open Server 15.7 Features