Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I m trying to insert file data in Oracle using Bulk . After running the job i m getting below error :
Also 2 files are getting created on disk with .csv and .csv.ctl extenstion But data is not getting loaded into oracle
tistics] connected
Exception in component tDBOutputBulkExec_1_tOBE (TapNgo)
java.io.IOException: Cannot run program "sqlldr": CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessBuilder.start(ProcessBuilder.java:1048)
at java.lang.Runtime.exec(Runtime.java:620)
at java.lang.Runtime.exec(Runtime.java:450)
at java.lang.Runtime.exec(Runtime.java:388)
at local_project.tapngo_0_1.TapNgo.tFileInputDelimited_1Process(TapNgo.java:2839)
at local_project.tapngo_0_1.TapNgo.runJobInTOS(TapNgo.java:3812)
at local_project.tapngo_0_1.TapNgo.main(TapNgo.java:3663)
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.<init>(ProcessImpl.java:386)
at java.lang.ProcessImpl.start(ProcessImpl.java:137)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:1029)
... 6 more