« Systematic Oracle Performance Tuning | Main | Using _spin_count to reduce latch contention in 11g »

January 28, 2008

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Diego Ucedo

Very useful piece of code.
I am wonder if it is possible to call a stored procedure from powershell scripting. This is a requirement for performance reason. Thanks.

Guy Harrison

Two methods for calling stored procedures. Firstly, if you just surround the stored procedure call with BEGIN .. END, then you can issue it as a NonQuery command. Eg:

$sql="begin mystoredproc; end;"
$command = New-Object Oracle.DataAccess.Client.OracleCommand( $sql,$conn)
$command.ExecuteNonQuery();

A slightly more correct way to do this would be to set the CommandType to "StoredProcedure". Then you don't need the BEGIN END:

$sql="mystoredproc"
$spCommand=New-Object Oracle.DataAccess.Client.OracleCommand( $sql,$conn)
$spCommand.CommandType="StoredProcedure"
$spCommand.ExecuteNonQuery();

buy viagra

Operating systems are a great help for all industries, I like musho read this type of operating system issues, I wonder if anyone knows about disadvantages of Windows 7, because I am unsure of using it, thanks!

Cheap Computers Canada

We all are always after new applications to speed up our work.

The comments to this entry are closed.