Copy large object data to a client file
The following example uses the lobs table created
in Figure 1.
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