Execute multiple queries in single Oracle command in C#

by

In order to execute more than one command put them in begin ... end; block.
And for DDL statements (like create table) run them with execute immediate. This code worked for me:

OracleConnection con = new OracleConnection(connectionString);
con.Open();

OracleCommand cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText =
    "begin " +
    "  execute immediate 'create table test1(name varchar2(50) not null)';" +
    "  execute immediate 'create table test2(name varchar2(50) not null)';" +
    "end;";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
con.Close();

More info: Executing SQL Scripts with Oracle.ODP

More Related Contents:

  1. C#: Oracle Data Type Equivalence with OracleDbType
  2. Converting seconds to hours,minutes and seconds [closed]
  3. SqlConnection.Open throwing exception C#
  4. c# when pressing a button add totals together [closed]
  5. What are the correct version numbers for C#?
  6. How to create and use resources in .NET
  7. Type or namespace name does not exist [closed]
  8. How to enable C# 6.0 feature in Visual Studio 2013?
  9. What is the best way to dump entire objects to a log in C#?
  10. OracleCommand SQL Parameters Binding
  11. How do you find all implementations of an interface?
  12. Very slow compile times on Visual Studio 2005
  13. How to run unit tests (MSTest) in parallel?
  14. Can the Oracle managed driver use async/await properly?
  15. How do I debug Windows services in Visual Studio?
  16. Regex to match all us phone number formats
  17. Why Visual Studio doesn’t create a public class by default? [duplicate]
  18. Additional Setup in Visual Studio Installer Projects
  19. The imported project “C:\Microsoft.CSharp.targets” was not found
  20. Non-nullable property must contain a non-null value when exiting constructor. Consider declaring the property as nullable
  21. update-database: “A network-related or instance-specific error occurred while establishing a connection to SQL Server”
  22. C# – How to get oracle long raw type value
  23. Connecting to Oracle Database through C#?
  24. IIS Express Immediately shutting-down running site after stopping web application
  25. Include ONLY .xml file of SPECIFIC nuget package in a different folder
  26. The name ‘ViewBag’ does not exist in the current context – Visual Studio 2015
  27. .NET Core include folder in publish
  28. How to create an installer for a .net Windows Service using Visual Studio
  29. Visual Studio 2015 diagnostics tool does not support current debugging configuration
  30. How to add config transformations for a custom config file in Visual Studio?

Leave a Comment