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 > 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@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@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@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 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: [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).
