1 Reply Latest reply: Jun 20, 2013 4:30 PM by chb RSS

    sql loader with windows 7

    949572
      hello,
      i am working on oracle forms 10.1.2.02 on windows 7 32 bit and oracle database 10g.
      i am trying to transfetr excel data in oracle database table.
      When i am tryng to run sqlldr from cmd(Running as Administrator) ,data successfully transfered.
      But when i try to perform this task via Oracle Forms I am getting

      SQLLoader-704: Internal error: ulconnect: OCIEnvCreate [-1]*

      THough I set oracle_home properly for oracle 10g C:\oracle\product\10.2.0\db_2

      Error.

      Why this error occured..

      Thanks.

      Edited by: Akarsh on Jan 31, 2013 9:54 PM
        • 1. Re: sql loader with windows 7
          chb

          Hi There,

           

          The problem is that when you run it from an Oracle Form your environment variables are gone. Create a batch file and run the batch file instead. Something like this:

          set oracle_home=c:\oracle\.....

          set PATH=%oracle_home%;%oracle_home%\bin;%PATH%

          %oracle_home%\bin\sqlldr ......

           

          I hope this help

           

          cb