|
SQL>
SQL> CREATE TABLE test_clob(
2 clob_id NUMBER,
3 clob_object CLOB
4 );
Table created.
SQL>
SQL> DECLARE
2 lv_clob_pointer_txt CLOB;
3 BEGIN
4 INSERT INTO test_clob (clob_id, clob_object)VALUES (1, '1234567890')
5 RETURNING clob_object INTO lv_clob_pointer_txt;
6 END;
7 /
PL/SQL procedure successfully completed.
SQL> drop table test_clob;
Table dropped.
|