The following
example creates a table with an lld_locator row and shows how to insert
a large object into the row. Figure 1: Insert an lld_locator row into a table
--Create lobs table
create table lobs (key int primary key, lo lld_locator);
-- Create an lld_locator for an existing server file
insert into lobs
values (1, "row('ifx_file',null,'/tmp/quote1.txt')");
The INSERT statement inserts an instance of an lld_locator
row into the lobs table. The protocol in the first field, IFX_FILE,
identifies the large object as a server file. The second field, lo_pointer,
is used to point to a smart large object. Because the object is a
server file, this field is NULL. The third field
identifies the server file as quote1.txt.