Re: Help! Long data types

Unfortunately, Oracle support for long columns is very limited. A pain I know from experience.

Note that Oracle states (somewhere) that LONGS have been superseded by Blobs which are much better supported.

This does require you to move to Oracle 8 and change your code. Not necessarily a small task.

Best of luck.

Arthur Merar wrote:

> Hello,
>
> Actually I have two questions.
>
> First, what is it with these long data types? Why can't I do anything
> with them? I need to compare to fields called NOTES in two different
> tables.....the NOTES field is of LONG data type.....how can I do this?
> I keep getting errors......
>
> Also, I run this query:
>
> select count(*) from TMP_POHEADER where
> ponum NOT IN (select ponum from POHEADER);
>
> That is a simple query right? There are even indexes on the PONUM
> field. Why then after 3 hours do I not get any results? There are
> only 30,000 records in the tables.....
>
> Any help would be appreciated....
>
> Thanks,
>
> Arthur
> amerar_at_unsu.com
Received on Fri Mar 19 1999 - 03:12:59 CST