write metho LOAD is aborting UPSERT running fine

karrisuresh · Post by **karrisuresh** » Thu Jun 28, 2007 12:26 pm

Hi
My source is file and target is oracle
when I am usng the upsert method
the records are getting populated in the target
but when I am using the load method
the job is getting aborted giving the following error
Oracle_Enterprise_2,2: sh: line 1: sqlldr: command not found

The call to sqlldr failed; the return code = 32,512;

Unable to access the log file.

Oracle_Enterprise_2,2: The runLocally() of the operator failed.

thanks

ray.wurlod · Post by **ray.wurlod** » Thu Jun 28, 2007 3:45 pm

sqlldr: Command not found

Says it all. Your PATH environment variable does not include the $ORACLE_HOME/bin directory and/or your ORACLE_HOME environment variable is not set.

keshav0307 · Post by **keshav0307** » Thu Jun 28, 2007 6:51 pm

the Load method use, SQL Bulk loader,
probably you may have not installed the Oracle sqlloader component.