Using Large Object text, unitext, and image Datatypes in Stored Procedures

The SAP ASE server allows you to declare a large object (LOB) text, image, or unitext datatype for a local variable, and pass that variable as an input parameter to a stored procedure, as well as prepare SQL statements that include LOB parameters.

The SAP ASE server caches SQL statements using LOB when you enable the statement cache. See Configuring Memory in the System Administration Guide, Volume 2.

These restrictions apply to using LOBs in stored procedures.