1 Reply Latest reply on Jun 20, 2013 9:30 PM by chb

    sql loader with windows 7

      i am working on oracle forms 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


      Why this error occured..


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

          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