SQL>
SQL> CREATE TABLE myClob
2 (id NUMBER PRIMARY KEY,
3 clob_data CLOB);
Table created.
SQL>
SQL> DECLARE
2 clobValue CLOB;
3 BEGIN
4 INSERT INTO myClob VALUES (104,EMPTY_CLOB())
5 RETURNING clob_data INTO clobValue;
6
7 END;
8 /
PL/SQL procedure successfully completed.
SQL>
SQL> drop table myClob;
Table dropped.
SQL>