Serves to execute series of SQL statements separated by special symbols.
This sample demonstrates how to execute script and retrieve information about execution flow using
Progress and
Error events.
|
|---|
[STAThread]
static void Main(string[] args)
{
string script =
"DROP TABLE DEPT;"+
"CREATE TABLE DEPT ("+
" DEPTNO NUMBER(38) NOT NULL,"+
" DNAME VARCHAR2(14),"+
" LOC VARCHAR2(13)"+
");"+
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+
"SELECT * FROM DEPT";
OracleConnection oracleConn = new OracleConnection(
"User Id=Scott;Password=tiger;Data Source=Ora;");
OracleScript oracleScript = new OracleScript(script,oracleConn);
oracleScript.Progress += new Devart.Common.ScriptProgressEventHandler(OnProgress);
oracleScript.Error += new Devart.Common.ScriptErrorEventHandler(OnError);
oracleConn.Open();
oracleScript.Execute();
oracleConn.Close();
}
static void OnProgress(object sender, Devart.Common.ScriptProgressEventArgs e)
{
Console.WriteLine(e.Text);
Console.WriteLine(" Successfully executed.");
}
static void OnError(object sender, Devart.Common.ScriptErrorEventArgs e)
{
e.Ignore = true;
Console.WriteLine(e.Text);
Console.WriteLine(" Failed.");
} |
|
|---|
Module Module1
Friend WithEvents oracleScript As Devart.Data.Oracle.OracleScript
Sub Main()
Dim script As String = _
"DROP TABLE DEPT;" & _
"CREATE TABLE DEPT (" & _
" DEPTNO NUMBER(38) NOT NULL," & _
" DNAME VARCHAR2(14)," & _
" LOC VARCHAR2(13)" & _
");" & _
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');" & _
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');" & _
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');" & _
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');" & _
"SELECT * FROM DEPT"
Dim oracleConn As OracleConnection = New OracleConnection( _
"User Id=Scott;Password=tiger;Data Source=Ora;")
oracleScript = New OracleScript(script, oracleConn)
oracleConn.Open()
oracleScript.Execute()
oracleConn.Close()
Console.ReadLine()
End Sub
Sub OnProgress(ByVal sender As Object, ByVal e As Devart.Common.ScriptProgressEventArgs) Handles oracleScript.Progress
Console.WriteLine(e.Text)
Console.WriteLine(" Successfully executed.")
End Sub
Sub OnError(ByVal sender As Object, ByVal e As Devart.Common.ScriptErrorEventArgs) Handles oracleScript.Error
e.Ignore = True
Console.WriteLine(e.Text)
Console.WriteLine(" Failed.")
End Sub
End Module |