Re: Using CLOB

<klone5399_at_my-deja.com> wrote in message news:7vpgv6$sr6$1_at_nnrp1.deja.com...
> "fumi" <fumi_at_tpts5.seed.net.tw> wrote:
> > dbms_lob.read is a procedure, can not be used in a SQL statement.
> > You can use:
> >
> > select rest_clob from test;
>
> I tried
> select test_clob from test;
>
> and got the following error
>
> ORA-00932: inconsistent datatypes

What tool did you use, and how did you execute the statement? I can not identify your enviromment by this error number.

In SQL*Plus, you can "see" the contents simply use the SQL statement.

In PL/SQL, you must declare a variable of CLOB type to get the locator of a CLOB, and then use dbms_lob.read to get the contents. Received on Thu Nov 04 1999 - 19:53:15 CST