Copy a large object to a large object

The following example uses the lobs table created in Insert an lld_locator row into a table.

The lld_copy function in the example copies large object data from one lld_locator type row to another.
Figure 1: Copy a large object to a large object
-- Copy an lld_locator to an lld_locator 
select lld_copy (S.lo, D.lo) from lobs S, lobs D where S.key = 1 and D.key = 2;


(expression)  ROW('IFX_CLOB      ','clob:ffffffffa6b7c8d9000000020000000300
          0000090000001a0000000000010000000000000ad3c3dc000000000b06eec8000
          00000005c4e6000607fdc000000000000000000000000',NULL) 


select lo.lo_pointer::clob from lobs where key = 2;


(expression)  
Ask not what your country can do for you,
but what you can do for your country.

The second SELECT statement casts lo.lo_pointer to a CLOB type to display the data in the column.