6
Answers

Call SQL Loader from C#

Datta Kharad

Datta Kharad

11y
13.4k
1
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)