Oracle Built−in Packages- P47: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Oracle Built-in Packages SEARCH Chapter 4 User Lock and Transaction Management NEXT DBMS_TRANSACTION Interfacing to SQL Transaction Statements The DBMS_TRANSACTION package provides a programmatic interface to a number of the SQL transaction statements. The majority of the DBMS_TRANSACTION programs have SQL equivalents that you can utilize directly from within SQL. For this reason developers and DBAs may choose to use the direct SQL equivalents rather than these procedures. A number of other procedures and functions have no equivalents however and nicely abstract the PL SQL programmer or database administrator from the internal details managed by the database. Getting Started with DBMS_TRANSACTION The DBMS_TRANSACTION package is created when the Oracle database is installed. The script found in the built-in packages source code directory as described in Chapter 1 contain the source code for this package s specification. This script is called by which is normally run immediately after database creation. The script creates the public synonym DBMS_TRANSACTION for the package and grants EXECUTE privilege on the package to public. All Oracle users can reference and make use of this package. DBMS_TRANSACTION programs Table lists the procedures and functions available through DBMS_TRANSACTION along with their SQL equivalents if applicable . Table DBMS_TRANSACTION Programs Name Description Use in SQL ADVISE_COMMIT Executes the equivalent of the ALTER SESSION ADVISE COMMIT command. Yes ADVISE_NOTHING Executes the equivalent of the ALTER SESSION ADVISE NOTHING command. Yes ADVISE_ROLLBACK Executes the equivalent of the ALTER SESSION ADVISE ROLLBACK command. Yes BEGIN_DISCRETE_TRANSACTION Sets the discrete transaction mode. No 221 Appendix A What s on the Companion Disk COMMIT Executes the equivalent of the COMMIT command. Yes COMMIT_COMMENT Executes the equivalent of the COMMIT COMMENT command. Yes COMMIT_FORCE Executes the .
