The following
example creates a smart large object containing CLOB type data. The lld_create function
in figure creates a smart large object. The first parameter to lld_create uses
the IFX_CLOB protocol to specify CLOB as the type of object to create.
The other two arguments are NULL.
The lld_create function
creates the CLOB type large object and returns an lld_locator row
that identifies it.
The insert statement inserts in the lobs table
the lld_locator row returned by lld_create. Figure 1: Using lld_create
--Create a new clob using lld_create
insert into lobs
values (2, lld_create ("row('ifx_clob',null,null)"::lld_locator));