Adaptive 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.
Prepare SQL statements that include LOB parameters.
Adaptive Server caches SQL statements using LOB when you enable the statement cache. See Chapter 3, “Configuring Memory,” in the System Administration Guide, Volume 2.
Certain restrictions apply to using LOBs in stored procedures.
LOB parameters are not supported for replication.
You cannot use LOB datatype for execute immediate and deferred compilation.
