Re: Oracle LONG type

Try to define long type in SQL*PLus like this:

sqlplus>col long_string format a6000;

then use insert in SQL*Plus. Hopefully it helps.

--Qing Miao
UCS,AT&T Ken Geng wrote:
>
> All,
> Following is the SQL that we use to extract data from one table to
> another:
>
> INSERT INTO bill_image_index
> SELECT * FROM bill_image_index_at_prod
> WHERE cust_id = '00002345';
>
> This type of query works fine if there no LONG type in the table. If
> a column of the table is defined as LONG, the following error occurs:
>
> ORA-00997: illegal use of LONG datatype.
>
> Any suggestion how to get around this Oracle limitation?
>
> Thanks in advance for any help.
>
> Ken.
Received on Thu May 08 1997 - 00:00:00 CDT