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 <[EMAIL PROTECTED]>
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
> CORE9.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@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 5
> SQL> COPY FROM SYSTEM/MANAGER@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 5. (long is 5)
> Table DEMO created.
>
>1 rows selected from SYSTEM@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@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 5. (long is 5)
>
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
