how to get full value of clob while debugging PL SQL script

Question

I'm using TOAD editor to write PL/SQL scripts. I cannot see value of a clob variable while debugging my script. I tried to add watch to_char(my_clob_variable), bu it didnt work.

Is there a way to see the clob value with toad's features or is there an other way around to do that? (Except updating scripts with dbms_output lines)

Answer 1

I struggled with this for a while and implemented the PL/SQL solution, but later realized that in Toad you can simply double click on the results grid cell, and it brings up an editor with contents in text.