2 Replies Latest reply: Mar 26, 2012 5:03 PM by AleemCh RSS

    MS PowerShell and Oracle


      Do you know about any whitepaper or documentation on connecting and executing DML/DDL statements from PowerShell?


        • 1. Re: MS PowerShell and Oracle
          gdarling - oracle
          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.

          • 2. Re: MS PowerShell and Oracle
            Hi Greg!

            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