Re: SQL*Plus: COPY command, LONG datatype, and ORA-01008

As a follow up, I think I found the reason why it doesn't work. One of the restrictions on the LONG datatype is that a LONG column cannot be used when inserting into a table with a query (i.e., INSERT INTO table_name SELECT col_1, col_2 FROM table_2). In essence, this is what the SQL*Plus COPY command is doing: INSERTing with a SELECT statement.

This being the case, however, I would have expected to receive the "ORA-00997: illegal use of LONG datatype" error, instead of the ORA-01008.

Thanks to all who replied.

Todd

Todd Owers wrote in message <72agf6$eqo$1_at_nntp.gulfsouth.verio.net>...
> [snip]
>The problem is that I am getting an "ORA-01008: not all variables bound"
>error on tables with a LONG column. On tables without a LONG column,
>everything works fine.
> [snip]
>Here is the script.
> [snip]
>COPY TO &un/&pw@&cs INSERT table_1 USING SELECT * from table_1
>COPY TO &un/&pw@&cs INSERT table_2 USING SELECT * from table_2
>etc... There are 14 tables in all, 2 of which contain LONG columns.
>
>As mentioned above, this script works fine for tables without a LONG
 column,
>but gives the ORA-01008 error for tables with a LONG column. Thanks in
>advance for your help and suggestions.
>
>Todd Owers
>toddo_at_gcr1.com
>
>
>
>
Received on Wed Nov 11 1998 - 00:00:00 CST