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

    SQL Loader for Oracle 11 instant client

    849163
      I am having trouble running sqlldr.exe on a machine that has Oralce 11.1.0.6 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?

      Thanks,
      -Chris
        • 1. Re: SQL Loader for Oracle 11 instant client
          19426
          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:

          http://www.nyoug.org/Presentations/2007/200703_Ji_Instant%20Client.pdf

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


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

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

            thanks,

            Manuel

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