SQL*Loader-704: Internal error: ulconnect: OCIEnvInit [-1] [message #71274] |
Tue, 08 October 2002 11:27 |
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
|
|
|
|
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 |
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
|
|
|
|