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.

• Declaring a LOB Datatype
  Use the declare function to declare an LOB datatype for a local variable.
• Creating a LOB Parameter
  Use the create procedure command to create an LOB parameter.
• Examples for Using LOB Datatypes
  Use LOB datatypes as the input parameter for a stored procedure, or in a text function.