Hi,
Does anyone have a sample job for Oracle Bulk Collect and Bulk Load?
On another note, my environment variables are set up correctly, however I'm still receiving the following error message.
Exception in component tOracleBulkExec_1
java.io.IOException: Cannot run program "sqlldr": java.io.IOException: error=2, No such file or directory
at java.lang.ProcessBuilder.start(ProcessBuilder.java:459)
at java.lang.Runtime.exec(Runtime.java:593)
at java.lang.Runtime.exec(Runtime.java:431)
at java.lang.Runtime.exec(Runtime.java:328)
at talendpractice.bulkcollecttest.BulkCollectTest.tOracleBulkExec_1Process(BulkCollectTest.java:545)
at talendpractice.bulkcollecttest.BulkCollectTest.tOracleInput_1Process(BulkCollectTest.java:436)
at talendpractice.bulkcollecttest.BulkCollectTest.runJobInTOS(BulkCollectTest.java:747)
at talendpractice.bulkcollecttest.BulkCollectTest.main(BulkCollectTest.java:666)
Caused by: java.io.IOException: java.io.IOException: error=2, No such file or directory
at java.lang.UNIXProcess.(UNIXProcess.java:148)
at java.lang.ProcessImpl.start(ProcessImpl.java:65)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:452)
can you make sure in the schema of the tOracleOutputBulkExec component you have the right Date Pattern for the ODATE column. The component should use this pattern for the sql loader. In any case seems like the sql loader is expecting the integer representation of the ODATE instead of a valid date pattern. In any case we should be able to transfer the ODATE into the desired integer form that oracle sql loader would accept using a tMap. Can also check to see which version of the sql loader you are using and also please attach the .ctl file created by talend.
thanks,
parham
