Oracle Using CONNECT, DISCONNECT, COMMIT, and ROLLBACK – PB Docs 126

Oracle Using CONNECT, DISCONNECT, COMMIT, and ROLLBACK

The following
table lists each transaction management statement and describes how
it works when you use any Oracle interface to connect to a database:

Statement

Description

CONNECT

Establishes the database connection.
After you assign values to the required properties of the transaction
object, you can execute a CONNECT. After the CONNECT completes successfully, PowerBuilder
automatically starts an Oracle transaction. This is the start of
a logical unit of work.

DISCONNECT

Terminates a successful connection. DISCONNECT automatically
executes a COMMIT to guarantee that all changes made to the database
since the beginning of the current unit of work are committed.

COMMIT

COMMIT terminates the logical unit of
work, guarantees that all changes made to the database since the
beginning of the current unit of work become permanent, and starts
a new logical unit of work.

ROLLBACK

ROLLBACK terminates a logical unit of
work, undoes all changes made to the database since the beginning
of the logical unit of work, and starts a new logical unit of work.

note.png

Oracle does not support the AutoCommit property of the
transaction object.

See also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x