SQL*Plus Copy Command Problem

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: Tue, 14 May 2002 15:57:41 +0000 (UTC)
Message-ID: <7361fed8e32ab515339ac24536b46ba2.38849@mygate.mailgate.org>

I am trying to insert some rows into a table containing a LONG, selected from a remote DB. It works ok in Unix (Oracle 8.1.7.2.0 on AIX), but not when using the client SQL*PLus (NT). The Oracle error message shown is not listed on their website. At first I thought the problem was that it couldn't find the message, but that the command was working. But that's not the case, the rows aren't inserted.

Any advice?

• Unix version

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production JServer Release 8.1.7.2.0 - 64bit Production

SQL> !cat copylong.sql
SPOOL copylong.log
SET AUTOTRACE OFF
SET LONG 2000

COPY FROM myuser/xxxx_at_remotedb       -
INSERT MY_TABLE                      -

USING SELECT * FROM MY_TABLE; SPOOL OFF SQL> @copylong

Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 2000. (long is 2000)

   9 rows selected from MYUSER_at_REMOTEDB.    9 rows inserted into MY_TABLE.
   9 rows committed into MY_TABLE at DEFAULT HOST connection.

SQL>

• NT error:

10:38:40 SQL> @copylong

ERROR:
ORA--3922282: Message -3922282 not found; product=RDBMS; facility=ORA

--

Posted via Mailgate.ORG Server - http://www.Mailgate.ORG Received on Tue May 14 2002 - 10:57:41 CDT