This content has been marked as final. Show 2 replies
You'd probably have better luck posting this in the ODP.NET forum, as this one is for .net stored procedures that reside inside the database.
To answer your question though, there's no Oracle specific documentation regarding PowerShell as there's nothing Oracle specific about it. However you'd go about executing any external .NET library should apply to using ODP.NET as well. However, if you have access to My Oracle Support, the following note may help you out with a simple example:
Using ODP.NET in Combination With Microsoft Powershell to Retrieve Data (Doc ID 848177.1)
Regarding general "executing DML/DDL statements from ODP.NET", if you need assistance with that, the following walkthrough should get you started:
Hope it helps, corrections/comments welcome.
Thanks for the help, and for pointing to the right group. I'll post future questions there
I am now able to perform DML, will also try DDL.
Thanks once again