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

you can use the SQL*Plus command COPY !

mfG Bernhard

Rich Tsui schrieb in Nachricht <3851AD8B.AE32946_at_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 Mon Dec 13 1999 - 16:17:54 CET