Re: displaying clob in sqlplus/toad

On Sep 5, 10:48 am, ap <cors..._at_ragingbull.com> wrote:
> On Sep 4, 7:48 pm, "phil_herr..._at_yahoo.com.au"
>
> <phil_herr..._at_yahoo.com.au> wrote:
> > 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
>
> 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

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 Received on Fri Sep 05 2008 - 11:32:36 CDT