multiple updates into oracle via C#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help
can I specify a string with mutiple update statements as the command statement using the .NET Managed Provider for Oracle? Or for that matter is there any way to do so from within c# into oracle
Thank you
Sa
 
Sam,

I don't know much about Oracle, but I know that SQL server will allow
you to place multiple statements into a string with a semi-colon delimiting
them. I can't imagine that Oracle doesn't allow the same thing. You just
have to find the delimiter and set the command text to a stirng delimited
with that character (or string of characters).

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Sam said:
Please help!
can I specify a string with mutiple update statements as the command
Click to expand...
statement using the .NET Managed Provider for Oracle? Or for that matter is
there any way to do so from within c# into oracle?
 
Sam,

You should be able to try a small test to see if it works. Just create
an OracleConnection and OracleCommand where it has multiple statements and
then try and execute it.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Sam said:
i found in the msdn documentation that using the oledb connection to
Click to expand...
oracle you can not specify mutiple statements into oracle. I therfore want
to know if you can do it using .NET Managed Provider for Oracle, or some
other way.
 
You are referring to a 'batch'.A batch is a group of one or more Transact-SQL statements sent at one time from an application to Microsoft SQL Server for execution.I believe that batches are limited to SQL Server and are not availibe for Oracle.
----- Nicholas Paldino [.NET/C# MVP] wrote: -----

Sam,

I don't know much about Oracle, but I know that SQL server will allow
you to place multiple statements into a string with a semi-colon delimiting
them. I can't imagine that Oracle doesn't allow the same thing. You just
have to find the delimiter and set the command text to a stirng delimited
with that character (or string of characters).

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Sam said:
Please help!
can I specify a string with mutiple update statements as the command
Click to expand...
statement using the .NET Managed Provider for Oracle? Or for that matter is
there any way to do so from within c# into oracle?
 
Back
Top