Re: Multiline_text query in Oracle 8i

"bb" <bijoy.bora_at_gmail.com> wrote in message news:1148606507.424600.118280_at_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

That something runs on a recent release doesn't mean it will run on previous releases (for obvious reasons,) and even the contrary is not always true.

What happens to be the data type of multiline_text.Data in 10g? Actually, LONG is very bad choice, migrate them to CLOBs or VARCHAR2s ASAP. You can do it pretty easily in 8.1.7, and you should never again choose LONG for anything. This data type is long time deprecated and eventually will be obsoleted and support for it removed.

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com