1 rem -----------------------------------------------------------------------
2 rem URL: http://www.orafaq.com/scripts/plsql/readlob.txt
3 rem Filename: readlob.sql
4 rem Purpose: Fetch LOB column values piece-wise from PL/SQL
6 rem Author: Frank Naude (frank@ibi.co.za)
7 rem -----------------------------------------------------------------------
11 DROP TABLE lob_table; -- Create table to hols LOBs
12 CREATE TABLE lob_table (
18 INSERT INTO lob_table -- Create sample record
19 VALUES (1, EMPTY_BLOB(), 'abcde', NULL);
27 -- First we need to get the lob locator
28 SELECT c_lob INTO clob_locator FROM lob_table WHERE id = 1;
30 DBMS_OUTPUT.PUT_LINE('CLOB Size: ' ||
31 DBMS_LOB.GETLENGTH(clob_locator));
33 -- Read LOB field contents
36 dbms_lob.read(clob_locator, read_amount, read_offset, charbuf);
37 dbms_output.put_line('CLOB Value: ' || charbuf);