Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Fail to copy a LONG datatype in Oracle to another table

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

From: Fu-Chiang (Rich) Tsui <tsui_at_cbmi.upmc.edu>
Date: Fri, 17 Dec 1999 11:43:09 -0500
Message-ID: <385A681D.3D74065E@cbmi.upmc.edu>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US