 | OracleUtility Class |
Provides various utility methods for use with Oracle databases.
Inheritance HierarchyNamespace: Galactic.Sql.Oracle
Assembly: Galactic.Sql.Oracle (in Galactic.Sql.Oracle.dll) Version: 1.3.0.499 (1.3.0.499)
SyntaxThe OracleUtility type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | OracleUtility | Initializes a new instance of the OracleUtility class |
Properties| Name | Description | |
|---|---|---|
 | MAX_NCHAR_LENGTH |
The maximum length of a NCHAR field in the database.
(Overrides SqlUtilityMAX_NCHAR_LENGTH.) |
| MAX_NVARCHAR_LENGTH |
The maximum length of a NVARCHAR field in the database.
(Overrides SqlUtilityMAX_NVARCHAR_LENGTH.) |
| MAX_VARCHAR_LENGTH |
The maximum length of a VARCHAR field in the database.
(Overrides SqlUtilityMAX_VARCHAR_LENGTH.) |
Methods| Name | Description | |
|---|---|---|
 | BuildConnectionString(String, String, String, Boolean, Boolean, String) |
Builds a connection string using TNS.
|
| BuildConnectionString(String, Int32, String, String, String, Boolean, Boolean, String) |
Builds a connection string.
|
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
| ExecuteNonQuery |
Executes the non-query PL/SQL command provided.
(Overrides SqlUtilityExecuteNonQuery(String, String, EventLog).) |
| ExecuteNonQuerySQLFile |
Executes the SQL statements in a file given its path, and a connection string to the database.
(Inherited from SqlUtility.) |
| ExecuteQuery(String, String, EventLog) |
Executes the PL/SQL query provided.
(Overrides SqlUtilityExecuteQuery(String, String, EventLog).) |
| ExecuteQuery(String, String, EventLog, Exception) |
Executes the PL/SQL query provided.
|
| ExecuteQuerySQLFile |
Executes the SQL query in a file given its path, and a connection string to the database.
(Inherited from SqlUtility.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| LogException(Exception, EventLog) |
Logs an exception to the event log.
(Inherited from SqlUtility.) |
| LogException(OracleException, EventLog) |
Logs an Oracle exception to the event log.
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| RunScript |
Runs SQL script files given their path.
(Inherited from SqlUtility.) |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Fields| Name | Description | |
|---|---|---|
 | DefaultPortNumber |
The default port number for Oracle database client connections.
|
See Also