Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using CLOB

Re: Using CLOB

From: <klone5399_at_my-deja.com>
Date: Wed, 03 Nov 1999 14:31:01 GMT
Message-ID: <7vpgv6$sr6$1@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




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Wed Nov 03 1999 - 08:31:01 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US