Fail to copy a LONG datatype in Oracle to another table
Date: Fri, 10 Dec 1999 20:48:59 -0500
Message-ID: <3851AD8B.AE32946_at_cbmi.upmc.edu>
[Quoted] Hi Oracle gurus,
[Quoted] 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 Sat Dec 11 1999 - 02:48:59 CET