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.
... View more