the call to sqlldr failed the return code = 1

VIDHATHA · Post by **VIDHATHA** » Mon Feb 11, 2013 7:38 am

Hi all,
Iam loading data from sqlserver to oracle using sqlserver stage and oracle enterprise stage. if the source having data in sqlserver there is no issue if there is no data its giving error"the call to sqlldr failed the return code = 1"
my target oracle option is load--append mode
can you please help me regarding this

Thanks

chulett · Post by **chulett** » Mon Feb 11, 2013 8:26 am

Unless someone else chimes in who knows better, I'd suggest you contact your official support provider and see if that is expected behaviour in that situation. You may need to 'test' your source first and only run the loader job if there is actual data to load.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 11, 2013 1:12 pm

I think that's just "how it works" - Oracle throws an error if you invoke sqlldr and provide a stream of 0 records. You should check first whether any records will be selected, and only execute the job if there are.

BillB · Post by **BillB** » Mon Feb 11, 2013 6:12 pm

Have a look at this viewtopic.php?t=119030 and see if it is relevant to your situation (it may not be).

VIDHATHA · Post by **VIDHATHA** » Thu Feb 14, 2013 6:03 am

Thank you so much BillB. its working fine after adding of ENV

thank you all.