This discussion is archived
2 Replies Latest reply: Mar 26, 2012 3:03 PM by AleemCh RSS

MS PowerShell and Oracle

AleemCh Newbie
Currently Being Moderated
Hi,

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

TIA!

Aleem
  • 1. Re: MS PowerShell and Oracle
    gdarling - oracle Expert
    Currently Being Moderated
    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:
    http://apex.oracle.com/pls/apex/f?p=44785:24:356172577471201:::24:P24_CONTENT_ID,P24_PREV_PAGE:4220,24

    Hope it helps, corrections/comments welcome.

    Greg
  • 2. Re: MS PowerShell and Oracle
    AleemCh Newbie
    Currently Being Moderated
    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

    Aleem

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points