Getting an error when use the Bulk load in oracle query

[Prakash_K]

Hi Team,

I am using a bulk load in oracle. But its not working as expected. Giving a below error.

Could you please advise

27         %put pathname = %sysfunc(pathname(work));

pathname = /data/sas/work/Bus/Dev/SAS_work174F00003C0D_clulup0027/SAS_workA06300003C0D_xxxxxx

28         %put getoptionpath = %sysfunc(getoption(work));

getoptionpath = /data/sas/work/Bus/Dev/SAS_work174F00003C0D_clulup0027/SAS_workA06300003C0D_xxxxxxxxx

29        

30         proc sql;

31         create table cdwmiusr.&test_prefix.claim_movements_polisy

32            (BULKLOAD=YES

33             BL_DATAFILE="%sysfunc(pathname(work))/polisy.dat"

34             BL_USE_PIPE=NO

35             BL_DELETE_DATAFILE=yes

36             BL_CONTROL = "%sysfunc(pathname(work))/polisy.ctl"

37              BL_LOG = "%sysfunc(pathname(work))/polisy.log"

38             bl_badfile = "%sysfunc(getoption(work))/polisy.bad"

39             bl_discardfile = "%sysfunc(getoption(work))/polisy.dsc"

40        

41              )

42             as select * from &test_prefix.claim_movements_polisy;

NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.

ERROR: The SQL*Loader utility failed to execute(OS RC=127). Some possible reasons:

-SQLLDR not installed.The cmd assumed is "sqlldr". If it is anything else use BL_SQLLDR_PATH to specify it.

-SQLLDR may be having trouble creating the log file.Make sure you have write permission to the dir where the log is

       created(default is current dir) If BL_LOG is specified, make sure the path specified is a valid one.

-Remove any double sets of quotes you may be having-keep only one set.

[Anand_V · Accepted solution]

Did you check this KB article? - http://support.sas.com/kb/57/192.html

[Prakash_K]

Thanks Anand.. Will try the solution!!