1 Reply Latest reply on Jul 14, 2014 10:04 AM by oralicious

    Question on SQL* Loader

    Purvesh K

      Hello Experts,

       

      I have a question w.r.t. SQL* Loader. Is there a way to configure the control file/parameter to force fail the loader if a minimum no. of records are not read from the file?

       

      My application fetches data from source system using SQL queries and there are times when there is no data to be read. Hence, I want my jobs to fail if they do not fetch any data. The job are written in Spring batches, which invokes the sqlldr utility to load the files into database.

       

      If there is an another way to accomplish this, suggestions are welcome.

       

      Oracle Version: 10.2.0.5

       

       

      Regards,

      Purvesh Kulkarni.