-
Title
No output was generated with no errors when SQL *Loader Wizard is launched -
Description
No output was generated with no errors when SQL *Loader Wizard is launched, or after running SQL Loader using a control file, the following message is displayed, but nothing had been loaded.
"Loader is finished"
-
Cause
May be missing sqlldr.exe in Oracle or a missing dll associated with sqlldr.exe
-
Resolution
RESOLUTION 1:Do a search in you Oracle directory for "sqlldr.exe." It's likely you might not find it. Consult Oracle if you do not find it. If you do find it do the following.
1. Go to View | Toad Options in TOAD
2. In the left panel, select Executable.
3. In the right panel, is there a path for the SQL Loader? If not click on the "..." icon next to the Flash light icon to find the path manually.RESOLUTION 2:
The SQL Loader file itself may be corrupted. Try running SQL Loader from the Windows Command Prompt to verify it is working correctly. Browse to the Oracle bin directory where sqlldr.exe is located and run the following command:
sqlldr username/password@database control=c:\loader.ctl
where loader.ctl is the control file. If this does not produce the correct results, then the issue is with the SQL Loader executable.