Re: COPY command in 9i

Hello Connor.
Tested this on 9.0.1.1.
Works fine when selecting from the same database. (The only 9 version db we have.).
When trying to access version 8.1.6 db got -1002 (trying to fetch after set is finished) no matter what array size I set.

Yechiel Adar, Mehish

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, April 04, 2002 11:48 PM

> Can anyone perform a similar test for me ? Some
> really cute results here:
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.0.1.2.1 -
> Production
> PL/SQL Release 9.0.1.2.1 - Production
> CORE 9.0.1.2.0 Production
> TNS for 32-bit Windows: Version 9.0.1.2.0 - Production
> NLSRTL Version 9.0.1.2.0 - Production
>
> SQL> conn system/manager
> Connected.
> SQL> COPY FROM SYSTEM/MANAGER_at_DB9 -
> > CREATE DEMO (BLAH) -
> > USING SELECT 'X' FROM DUAL;
>
> Array fetch/bind size is 15. (arraysize is 15)
> Will commit when done. (copycommit is 0)
> Maximum long size is 80. (long is 80)
>
> ERROR:
> ORA--18971416: Message -18971416 not found;
> product=RDBMS; facility=ORA
>
> (Now there's an interesting error number!)
>
> SQL> set arraysize 1
> SQL> set long 50000
> SQL> COPY FROM SYSTEM/MANAGER_at_DB9 -
> > CREATE DEMO (BLAH) -
> > USING SELECT 'X' FROM DUAL;
>
> Array fetch/bind size is 1. (arraysize is 1)
> Will commit when done. (copycommit is 0)
> Maximum long size is 50000. (long is 50000)
> Table DEMO created.
>
> 1 rows selected from SYSTEM_at_DB9.
> 1 rows inserted into DEMO.
> 1 rows committed into DEMO at DEFAULT HOST
> connection.
>
> (So it looks like arraysize etc could be the
> workaround - but there is no rhyme or reason to this -
> in other tests it worked UNTIL I changed arraysize.
> Similarly, straight after the above, I repeat the test
> to a different table name...)
>
> SQL> COPY FROM SYSTEM/MANAGER_at_DB9 -
> > CREATE DEMO2 (BLAH) -
> > USING SELECT 'X' FROM DUAL;
>
> Array fetch/bind size is 1. (arraysize is 1)
> Will commit when done. (copycommit is 0)
> Maximum long size is 50000. (long is 50000)
>
> ERROR:
> ORA-03114: not connected to ORACLE
>
> No such problems on Solaris 9.0.1.3 - can anyone
> reproduce under NT 9.0.1.2 if they've got it?
>
> Charming eh?
>
> =====
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adaryechiel_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).