1 Reply Latest reply on Jul 16, 2020 6:10 PM by thatJeffSmith-Oracle

    SQL Loader Error while uldlfca:

    1007945

      I am doing control file and my control file look as below very simple but don't know I am getting below error message

      if I have load less data it is working fine if I am loading 10000 records it is throwing below error message

      can some help this issue....

       

      OPTIONS (DIRECT=TRUE, ERRORS=10)

      load data

      INFILE 'c:\Inventory.csv'

      truncate

      into table NVENTORY_2

      fields terminated by ','

      OPTIONALLY ENCLOSED BY '"' AND '"'

      trailing nullcols

      (

      ID,

      name,

      WL, 

      BYE

      )

       

       

      Path used:      Direct

      SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

      SQL*Loader-925: Error while uldlfca: OCIStmtExecute (ptc_hp)

      ORA-03114: not connected to ORACLE

      SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

      SQL*Loader-925: Error while uldlgs: OCIStmtExecute (ptc_hp)

      ORA-03114: not connected to ORACLE

      SQL*Loader-925: Error while uldlgs: OCIStmtFetch (ptc_hp)

      ORA-24338: statement handle not executed