Hello,
How to run command SQLLoader Oracle in c#. I try my sourcode for run this SQLLoader, but nothing happen and error "No process is associated with this object.". Please tell me how i fix it. Thanks.
This is my code:
System.Diagnostics.Process process1;
process1 = new System.Diagnostics.Process();
process1.EnableRaisingEvents = false;
string strCmdLine;
strCmdLine = @"/C SQLLDR XL/secreat@O11G CONTROL=E:\APT\LoadXL.ctl";
System.Diagnostics.Process.Start("CMD.exe", strCmdLine);
process1.WaitForExit();
process1.Close();
Loading
Datta KharadPosted Mar 2, 2012, 4:43 AM
I got solution on above problem. See the below Solved Solution
http://www.c-sharpcorner.com/Forums/Thread/162723/call-sql-loader-from-C-Sharp.aspx
Datta KharadPosted Feb 25, 2012, 5:26 AM
I got same error while calling 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();
Suthish NairPosted Mar 12, 2011, 12:51 PM
Guest UserPosted Mar 10, 2011, 9:25 AM
Process p = new Process();
p.StartInfo.FileName = @"
p.StartInfo.Arguments = @"
p.StartInfo.UseShellExecute = false;
p.StartInfo.RedirectStandardOutput = false;
p.Start();
p.WaitForExit();
p.Close();