Getting an error when use the Bulk load in oracle query

Prakash_K — Wed, 04 Mar 2020 13:32:48 GMT

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

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"

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.

Re: Getting an error when use the Bulk load in oracle query

AnandVyas — Wed, 04 Mar 2020 14:21:37 GMT

Prakash_K — Thu, 05 Mar 2020 13:04:35 GMT

Thanks Anand.. Will try the solution!!