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

Home -> Community -> Usenet -> c.d.o.misc -> Multiline_text query in Oracle 8i

Multiline_text query in Oracle 8i

From: bb <bijoy.bora_at_gmail.com>
Date: 25 May 2006 18:21:47 -0700
Message-ID: <1148606507.424600.118280@u72g2000cwu.googlegroups.com> 





When I run the following command in Oracle 8.1.7, to check the length
of "data" in the "multiline_text" table where data for a field name
"description" is stored, it returns an error:



select Length(Data) from multiline_text;
ORA-00932:inconsistent datatypes



But the same command runs firn for 10G



Looks like "Long" type cannot be used here. Shall appreciate if anyone
has an idea how to get the multiline field(long) with Oracle 8.1.7



Thx in advance



Bora
Received on Thu May 25 2006 - 20:21:47 CDT












Original text of this message













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