Oracle LONG type

From: Ken Geng <ken.geng_at_cbis.com>
Date: 1997/04/21
Message-ID: <335B77B8.36F3@cbis.com>#1/1

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 Mon Apr 21 1997 - 00:00:00 CDT