Re: More: ORA-01013, "user requested cancel of current operation"

[Paul Cruz <pcruz@ALGOMA.COM>]

Just adding my 2 cents..
This is a known bug in Oracle RDBMS ver 7.2 ( not sure if it also exist in
7.3). We encountered this same problem on a script (not written in SQR) that
does the same thing, loading from a flat file. Oracle Support should be able
to provide you a patch for it.

-----Original Message-----
From: Eric Dimick Eastman <erice@ONTKO.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: Sunday, July 05, 1998 6:18 PM
Subject: Re: More: ORA-01013, "user requested cancel of current operation"


>Hello,
>
>I posted a message about this exact problem a while ago and have had it
>as an ongoing problem for the last year.  I get it while loading flat
>files into Oracle.  There doesn't seem to be any rhyme or reason to it.
>I have worked around this problem by making my load programs robust.
>I have a on-error clause on each begin-sql and begin-select that prints
>an error to a log file and puts the offending datafile lines in an error
>file to be re-run.  I get that error about 1 record per 100,000.
>
>I will continue to work on this problem, and if find anything out I
>would love to hear it.
>
>Thanks,
>Eric
>
>On Fri, 3 Jul 1998, jlwyant wrote:
>
>> All,
>>
>> Thanks to everyone who has already responded.
>>
>> As I mentioned early I'm passing this message on for a friend... I have
>> a few more details and now know that he did not press control-c or any
>> other cancelling operation. I do know that he is loading flat files into
>> Oracle. He has been able to load small tables with ten thousand records
>> or less. It is the larger loads that appear to quit with the ORA-01013
>> error. He informs me that after running the same SQR multiple times it
>> never errors in the same procedure or record count. I suggested as a
>> wild guess that he try issuing a commit after say 500 hundred inserts.
>> My thinking here is the possibility of a full rollback segment.
>>
>> Thanks for all your help. Jim
>>
>
>------------------------------------------------------------------------
>Eric Dimick Eastman  |Ray Ontko & Co | This space for rent.
>erice@ontko.com      |Richmond, IN   | Your opinion here.
>http://www.ontko.com |               |