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

[Charles Thompson <THOMPSONC@TRANSPOWER.CO.NZ>]

Have you tried these various suggestions :

1.  Set your program to commit at regular intervals, say every 50,000
lines.  You may even want to exit SQR and rerun the program again
after every 50,000 lines (skipping lines already processed).

2.  Check your database engine's use of memory (SGA) -- a DBA should
be able to help with this.  A trace on the database while your program
is executing should be informative.

3.  Check the version of Oracle, and have your DBA double-check with
Oracle Support on the current version.  There may be a patch release
that helps your program.

4.  This may sound silly, but you should also check for any database
constraints, such as tablespace quotas for your user.

5.  Simplify your program so that all it does is open the file, read a
line, insert into a single table. read the next line, etc.  If this
works for all your records, try again with a little bit more
functionality, and keep going until it crashes again.

I had a similar problem a few years ago.  I ended up rewriting the
program (giving me the chance to improve on it a little), and the
problem went away.

Good luck
- Charles Thompson