LISTING 3: Write LOB in SQL_TEXT

SQL> select sql_text from v$open_cursor;

SQL_TEXT
-----------------------------------
select sql_text from v$open_cursor


SQL> declare
  2     l_clob clob;
  3  begin
  4     select x into l_clob from t FOR UPDATE;
  5     dbms_lob.open( l_clob, dbms_lob.lob_readwrite );

  6  end;
  7  /
PL/SQL procedure successfully completed.

SQL> select sql_text from v$open_cursor;

SQL_TEXT

-----------------------------------
table_e_400_9912_1_0_0
select sql_text from v$open_cursor