Oracle 9.2.0.5 and sqlldr problems

From: Don Seiler <don_at_seiler.us>
Date: Tue, 06 Apr 2004 15:41:53 GMT
Message-ID: <pan.2004.04.06.15.48.18.114073@seiler.us>

One of my developers just emailed me with the issue I've quoted below. The "upgrade" he mentions was the recent patch from Oracle 9.2.0.4 to 9.2.0.5. This is an x86 box running RHEL 3.0 ES. I've read a "horror stories" thread on 9.2.0.5. Should I consider downgrading the box back to 9.2.0.4 or should I encourage them to do some datafile checking before calling sqlldr to avoid this problem?

BEGIN QUOTE
We are having some problems with the sql loader problem. Before the upgrades, sql loader would run fine if we passed in an empty datafile. After the upgrade we get this error:

SQL*Loader-961: Error calling once/load finishing for table RATE.CELLSITE_0040220
ORA-00604: error occurred at recursive SQL level 1 ORA-01001: invalid cursor
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue. END QUOTE Received on Tue Apr 06 2004 - 10:41:53 CDT