Home » RDBMS Server » Server Utilities » SQL*Loader-704: Internal error: ulconnect: OCIEnvInit [-1]
SQL*Loader-704: Internal error: ulconnect: OCIEnvInit [-1] [message #71274] Tue, 08 October 2002 11:27 Go to next message
BG
Messages: 3
Registered: September 2002
Junior Member
Hello,
I am getting the below error message when trying to load data into my tables using sql loader.

SQL*Loader-704: Internal error: ulconnect: OCIEnvInit [[-1]]

One interesting point I noticed is that, although I just upgraded from 8i to 9i, I see that

SQL*Loader: Release 8.1.7.0.0 is openning up from the ctl file.

I'd appreciate if anyone could help solving this problem.
Thx
BG
Re: SQL*Loader-704: Internal error: ulconnect: OCIEnvInit [-1] [message #71276 is a reply to message #71274] Tue, 08 October 2002 12:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try again after changing
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
to
ORA_NLS33=$ORACLE_RDBMS/ocommon/nls/admin/data
SQL*Loader-704: Internal error: Maximum record length must be <= [10000000] [message #71833 is a reply to message #71274] Fri, 17 January 2003 07:47 Go to previous messageGo to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
I am seeing a similar error and I am hoping that some one may have a suggestion.

I am working from a windows 2000 PC. I am using the sqlldr utility for oracle8i. I am loading several flat files calling the sqlldr repetitively from a batch file.

When the batch file runs most of the calls to the sqlldr run with out error but a couple of the calls result in this error

SQL*Loader-704: Internal error: Maximum record length must be <= [[10000000]]

What is odd is that all of the input files are generated by the same program and each record is terminated with a new line character. None of the records in the files exceed 212 characters. Yet the error only occurs on a few of the files. I have NOT been able to identify anything that the failing input files have in common that may be causing the problem.

I am unable to find a record that is not terminated by a new line character or one that exceeds 212 characters.

Any suggestion or help is appreciated.

J.Trotta
Re: SQL*Loader-704: Internal error: Maximum record length must be <= [10000000] [message #71834 is a reply to message #71274] Fri, 17 January 2003 07:56 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are you using bindsize in sqlldr script?

[Updated on: Mon, 19 October 2009 14:15]

Report message to a moderator

Previous Topic: Export vs Physical database backup
Next Topic: Re: Error 1053: The service did not respond to the start or control request in a timely fashion.
Goto Forum:
  


Current Time: Tue Apr 16 07:17:21 CDT 2024