Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Successful use of [Oracle.DataAccess.Client] is based on proper understanding of three separate parts of Oracle:

  • SQL
  • PL/SQL
  • sql*plus

Here on the following questions target this topic:

How to differentiate between sql and pl/sql?

Execute pl sql script block in c?

What is the difference between terminating an oracle sql statement with semicolon?

How can i catch the output of dbms output put line when executing a block using [Oracle.DataAccess.Client]?

The task I want finally to solve is a way to take an arbitrary sql*plus script and dissect it into parts, that can be handled by ADO.NET.

There is a codeplex Powershell project SQLPSX to which I contribute.

It's capabilities to handle sql-server scripts with the SQLIse module are quite useful.

But it's Oracle module OracleIse currently just handles single SQL statments like

select * from Test_call_count


update Test_call_count set count = count + 1 


Create table Test_call_count (
    count number(10)

Using ExecuteNonQuery it would be possible to execute simple blocks

begin; update Test_call_count set count = count + 1; end;

Later some support for client variables like

var r refcursor

will be needed to fetch the result sets from stored procedures and bind variables.

I hope, that this eventually becomes a CW where we collect some valuable links for the basic understanding of the Oracle query tools, which help all who want to dive into the Oracle DataAcess componets and me improving OracleIse.

share|improve this question

closed as not a real question by Chris Travers, Mark Storey-Smith, ypercubeᵀᴹ, dezso, Marian Feb 25 '13 at 14:29

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.