Datta Kharad

Datta Kharad

  • NA
  • 1.6k
  • 53.4k

Call SQL Loader from C#

Feb 25 2012 5:22 AM
HI
   How to run command SQLLoader Oracle in c#. I am trying for run this SQLLoader, but out of 80000 rows only 71000 rows inserted into table and lastly throwing error "No process is associated with this object." at process1.WaitForExit();. Please tell me how i remove this error. Thanks.
This is my code:

System.Diagnostics.Process process1;
process1 = new System.Diagnostics.Process();
process1.EnableRaisingEvents = false;

string strCmdLine;
strCmdLine = @"/C SQLLDR user/pwd@O11G CONTROL=D:\ControlFile.ctl";
System.Diagnostics.Process.Start("CMD.exe", strCmdLine);
process1.WaitForExit();
process1.Close();

Answers (6)