The following example uses the lobs table created
in Insert an lld_locator row into a table.
The lld_toclient function in Copy large object data to a client file copies large object data to the output.txt client
file. This function returns t when the function succeeds.
The SELECT statement returns t, or true,
indicating that the function returned successfully. Figure 1: Copy large object data to a client
file
-- Copy an lld_locator to a client file
select lld_toclient (lo, 'output.txt') from lobs where key = 2;
(expression)
t