Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

displaying clob in sqlplus/toad

1,122 views
Skip to first unread message

ap

unread,
Sep 4, 2008, 5:33:13 PM9/4/08
to
Hello all,

I have a client that is written using a script that inserts data into
clob data fields and these columns exceed 32K. It looks like the
writes to the lobs are suceeding from the client, but I am unable to
view them data from either sqlplus nor toad.

How would I be able to display clob fields via sqlplus or
toad for data types > 32K?

Thank you!

phil_h...@yahoo.com.au

unread,
Sep 4, 2008, 7:48:14 PM9/4/08
to
In TOAD, locate the row in a schema browser window, then double-click
on the CLOB icon. In the BLOB edit window, click on the 'save to a
file' button.

-- Phil

ap

unread,
Sep 5, 2008, 11:48:37 AM9/5/08
to
On Sep 4, 7:48 pm, "phil_herr...@yahoo.com.au"

Thanks, but I'm using the 8.0.0.47 (commercial) version and don't see
a clob nor lob icon. Is this something to configure? Where do you get
this icon?

Also, does dbms_lob calls work on sql editor?

Thanks

ora...@msn.com

unread,
Sep 5, 2008, 12:32:36 PM9/5/08
to

You're several releases behind on TOAD, as the current release is
9.6.1.1. I expect you won't find such an icon in your release, as I
suspect it was written prior to the implementation of LOBs.


David Fitzjarrell

0 new messages