ODAC

TOraSession Members

TOraSession class overview.

Properties

Name Description

AutoCommit

Used to permit or prevent permanent updates, insertions, and deletions of data associated with the current transaction against the database server.

ConnectDialog (inherited from TCustomDAConnection)

Allows to link a TCustomConnectDialog component.

Connected

Used to indicate if the database connection is active.

ConnectMode

Used to specify the system privileges to use when a user connects to the server.

ConnectPrompt

Used to supply a prompt for a name and password.

ConnectString (inherited from TCustomDAConnection)

Used to specify the connection information, such as: UserName, Password, Server, etc.

ConvertEOL (inherited from TCustomDAConnection)

Allows customizing line breaks in string fields and parameters.

Debug

Used to display SQL statements being executed with their parameter values and data types.

Home

Used to specify the Oracle client to be used in the application.

HomeName

Used to select the Oracle client to use with the application.

HttpOptions

Used to set up the HTTP options.

InternalName

Used to get or set the client database name that will be recorded when performing global transactions.

InTransaction (inherited from TCustomDAConnection)

Indicates whether the transaction is active.

LastError

Used to get an error code which resulted from previous call to the OCI interface function.

LDA

Provides a pointer to Oracle 7 login data area of the current connection.

LoginPrompt (inherited from TCustomDAConnection)

Specifies whether a login dialog appears immediately before opening a new connection.

OCICallStyle

Indicates the set of OCI routines used.

OCISvcCtx

Used to return Oracle 8 service context handle of the current connection.

Options

Used to specify the behaviour of a TOraSession object.

OracleVersion

Used to get Oracle server version number as string.

Password

Used to specify a password for a connection.

Pooling (inherited from TCustomDAConnection)

Enables or disables using connection pool.

PoolingOptions

Used to specify the behaviour of connection pool.

ProxySession

Used to enable multiple user sessions within a single database session.

Schema

Used to change the current schema of the session to the specified schema.

Server

Contains the server name.

SQL

Uses embedded TOraSQL object to execute any SQL statement.

SSLOptions

Used to set up the SSL options.

ThreadSafety

Used to allow the usage of the OCI in multi-threaded environment.

Username

Contains username.

Methods

Name Description

ApplyUpdates (inherited from TCustomDAConnection)

Overloaded. Applies changes in datasets.

AssignConnect

Shares database connection between the TOraSession components.

AssignLDA

The method is used to assign LDA handle.

AssignSvcCtx

Overloaded. The method is used to assign service context handle.

ChangePassword

Changes the password of an account to the new password.

Commit (inherited from TCustomDAConnection)

Commits current transaction.

Connect (inherited from TCustomDAConnection)

Establishes a connection to the server.

CreateSQL (inherited from TCustomDAConnection)

Creates a component for queries execution.

Disconnect (inherited from TCustomDAConnection)

Performs disconnect.

ExecProc (inherited from TCustomDAConnection)

Allows to execute stored procedure or function providing its name and parameters.

ExecProcEx (inherited from TCustomDAConnection)

Allows to execute a stored procedure or function.

ExecSQL (inherited from TCustomDAConnection)

Executes a SQL statement with parameters.

ExecSQLEx (inherited from TCustomDAConnection)

Executes any SQL statement outside the TQuery or TSQL components.

GetDatabaseNames (inherited from TCustomDAConnection)

Returns a database list from the server.

GetKeyFieldNames (inherited from TCustomDAConnection)

Provides a list of available key field names.

GetSequenceNames

Provides the names of available sequences.

GetStoredProcNames (inherited from TCustomDAConnection)

Returns a list of stored procedures from the server.

GetTableNames (inherited from TCustomDAConnection)

Provides a list of available tables names.

MonitorMessage (inherited from TCustomDAConnection)

Sends a specified message through the TCustomDASQLMonitor component.

ParamByName

Provides access to OUT parameters and their values after processing SQL statement with ExecSQL or stored procedure with ExecProc.

Ping (inherited from TCustomDAConnection)

Used to check state of connection to the server.

RemoveFromPool (inherited from TCustomDAConnection)

Marks the connection that should not be returned to the pool after disconnect.

Rollback (inherited from TCustomDAConnection)

Discards all current data changes and ends transaction.

RollbackToSavepoint

Cancels all updates for the current transaction.

Savepoint

Defines a point in the transaction to which you can roll back later.

StartTransaction

Overloaded. Begins a new user transaction against the database server.

Events

Name Description

OnConnectChange

Occurs after Connected property was changed.

OnConnectionLost (inherited from TCustomDAConnection)

This event occurs when connection was lost.

OnError (inherited from TCustomDAConnection)

This event occurs when an error has arisen in the connection.

OnFailover

Occurs when Transparent Application Failover (TAF) seamlessly attempts to failover to another Oracle instance.

OnInfoMessage

The event occurs if the server returned the OCI_SUCCESS_WITH_INFO error.
© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback