PUBLIC:Re: Need substring of a long field - help please

Amy Grant wrote:
>
> I have a field with the datatype of long and I need the first 255
> characters of it. I get an error of ORA-00932: inconsistent datatypes when
> I try it. Any suggestions on how I can do this?
>
> I would really appreciate it if you could email to agrant_at_3si.com.
>
> Thanks,
>
> Amy

Hi Amy

SQL-Functions on longs are not allowed. If you do a simple select in the SQL*Plus you can set the long varaible to
255 and you'll get it (e.g. SQL> set long 255). The default is 80.

HtH
eugen Received on Fri May 08 1998 - 06:30:00 CDT