2 Replies Latest reply: Jan 21, 2013 1:55 PM by 986216 RSS

    SQL Loader for Oracle 11 instant client

      I am having trouble running sqlldr.exe on a machine that has Oralce instant client installed. I have already copied over all of the DLL files that it said it needed and the whole RDBMS directory from a machine with the full install. This is the error I am getting:

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

      I don't have any trouble connecting to anything using sqldeveloper. Are there any files or steps I am missing?

        • 1. Re: SQL Loader for Oracle 11 instant client
          The only supported add-on for the Instant Client is sqlplus, integration of other utilities is not supported. You cannot simply mix DLLs from different software packages. There are some documents about workarounds, for example:


          But no guarantee that it works and no support from Oracle.

          • 2. Re: SQL Loader for Oracle 11 instant client
            hi ..

            I know the thread is discontinued, but...
            Is there any documentation for doing this on windows 7 ?
            The link is for Unix/Linux.



            Edited by: 983213 on Jan 21, 2013 11:55 AM