Re: Fail to copy a LONG datatype in Oracle to another table

Thank you all for answering my question. I did solve it by setting the LongReadLen and LongTruncOk variables in perl.

Rich

Rich Tsui wrote:
>
> 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 17 1999 - 10:43:09 CST