48.10 CLOSE_OPEN_DB_LINKS Procedure

This procedure closes all open database links for the current database session.

It is rare for this procedure to be called programatically in an application. The primary purpose of this procedure is for the middleware technology in an Oracle APEX environment (such as Oracle REST Data Service or ORDS, mod_plsql) to be configured such that it closes all of the open database links in a session, either before a request is made to the APEX engine, or after a request to the APEX engine is completed but before the database session is returned to the pool.

Syntax

APEX_UTIL.CLOSE_OPEN_DB_LINKS

Parameters

None.

Example

In this example, the configuration of Oracle REST Data Services (ORDS) closes any open database links both before the request is made to the APEX engine and after the request is complete.

    <entry key="procedure.postProcess">apex_util.close_open_db_links</entry>
    <entry key="procedure.preProcess">apex_util.close_open_db_links</entry>

When using Oracle HTTP Server and mod_plsql, this configuration looks like this:

    PlsqlBeforeProcedure	apex_util.close_open_db_links
    PlsqlAfterProcedure		apex_util.close_open_db_links