When you are loading data to Oracle from SAS^® on a UNIX machine, and you are using the BULKLOAD=YES options, this error or similar might occur:

The error occurs if the PATH environment variable does not include the directory that contains the sqlldr executable file for the SQL*Loader program.

To Resolve the Issue

To resolve this problem, use one of the following options:

• Use the BL_SQLLDR_PATH="directory_where_sqlldr_program_resides/sqlldr" option with the BULKLOAD=YES option.
  In the example below, the SQL*Loader program resides in the '/opt/oracle/product/11.2.0.3.5/bin' directory.
  data oralib.oratest1(BULKLOAD=yes BL_SQLLDR_PATH='/opt/oracle/product/11.2.0.3.5/bin/sqlldr'); c1=1; run;
• Add the location of the SQL*Loader executable to the PATH environment variable. Typically, you can find the SQL*Loader executable in the ORACLE_HOME/bin directory.
  Run these commands before starting SAS from a UNIX command line: PATH=$ORACLE_HOME/bin:$PATH export PATH
  If you are running SAS using SAS^® Business Intelligence clients such SAS^® Enterprise Guide^® or SAS^® Data Integration Studio, add the above commands to the sasenv_local file.

Operating System and Release Information