Fail to copy a LONG datatype in Oracle to another table

From: Rich Tsui <tsui_at_cbmi.upmc.edu>
Date: Fri, 10 Dec 1999 20:48:59 -0500
Message-ID: <3851AD8B.AE32946@cbmi.upmc.edu>

Hi Oracle gurus,

I have trouble in copying a LONG datatype column of data to another table via
"INSERT INTO tableA (A_col_NUM, A_col_LONG)

SELECT B_col_NUM, B_col_LONG FROM tableB", where the A_col_LONG and B_col_LONG represent the LONG datatype.

The error message I got from the sqlplus is: ORA-00997: illegal use of LONG datatype

I suspect it's a bug in Oracle 8.0.4. If you know how to solve this problem, please let me know. Thank you in advance.

Additionally, I even tried to use DBI in PERL to read a LONG datatype, and it also ended up with the following error message, DBD::Oracle::st fetchrow failed: ORA-24345: A Truncation or null fetch error occurred (DBD ERROR: ORA-01406 error on field 1 of 1, ora_type 8) at cp_table.pl line 25. (Line 25 has the command $sth->fetchrow())

Here is the basic information,
Server: Oracle 8.0.4.0.0
OS: Solaris 2.5
Box: Sun's enterprise 10K
PERL: 5.00403 Rich Received on Fri Dec 10 1999 - 19:48:59 CST