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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Execute scripts from C# without sqlcl

JoelFromBoschAug 14 2024 — edited Aug 14 2024

We have prepared .sql scripts that migrate/set up our Oracle database schema and need to execute them as part of an automated database migration process. The tool that does this is written in .NET 8 / C#.

Is there a way to do this without having to spin up some sqlcl process that in turn executes the script file?

We noticed that ODP.NETs .ExecuteNonQuery() accepts only isolated statements and ran out of ideas.

Comments
Post Details
Added on Aug 14 2024
3 comments
88 views