Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OracleCommand, Invalid SQL

526888Aug 7 2006 — edited Aug 10 2006
I wish to make a backup, with host copy operation (using ASP.NET) but got problems with double backslash \\ occuring in my OracleCommand, got always exception "Invalid SQL", here's my command (.txt only as example):

OracleCommand oraCmdCopy = new OracleCommand(String.Format("host copy {0} {1}", @"D:\a.txt", @"F:\b.txt"), oraConn);

I've put a watch there's always:
D:\\a.txt
F:\\b.txt

I've tried with String.Replace(@"\\",@"\")...

but there is no positive result..

Can anyone tell me how to handle that situation?
[Oracle accepts D:\a.txt, but not D:/a.txt, tried that also...] is this double backslash a problem or should I use something else, not OracleCommand to execute that statement.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2006
Added on Aug 7 2006
4 comments
651 views