Solution from myself... maybe if somebody needs this...
String sqlScript = "Select * from Dump";
mySqlConn = new gl2ora.SqlCon(OracleSID, OracleUsername, OraclePassword);
myOraConn = mySqlConn.Make();
Oracle.DataAccess.Client.OracleTransaction myOracleTransaction = myOraConn.BeginTransaction();
Oracle.DataAccess.Client.OracleCommand _cmd = myOraConn.CreateCommand();
_cmd.CommandText = sqlScript;
try
{
_cmd.ExecuteNonQuery();
}
catch (System.Exception _ex)
{
//Error
myOracleTransaction.Rollback();
return false;
}
}
//All done
myOracleTransaction.Commit();