Search Results dbms_ldap




Overview
Explore in AI Chat

Overview

The SYS.DBMS_LDAP package body is the underlying implementation of Oracle's PL/SQL interface to Lightweight Directory Access Protocol (LDAP) directories. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments it forms the foundation of the Oracle Internet Directory (OID) and Oracle Access Manager (OAM) integration used by EBS for centralised user authentication, single sign-on (SSO), and directory synchronisation. The package is owned by the SYS schema and is validated as VALID in the ETRM 12.2.2 dictionary. It is classified as an OTHER API, reflecting that it is a generic Oracle Database-supplied utility rather than an EBS application API.

The package body exposes 45 documented procedures and functions and, per the dependency metadata, is referenced by two other database objects. It is not, in turn, referenced by any further dependent object beyond those, which confines the surface of the interface to its direct consumers.

Key Procedures and Functions

The documented subprograms fall into several functional groups. Directory connection and session handling is performed by INIT, which establishes a session against the LDAP server. Authentication is handled by SIMPLE_BIND_S and BIND_S, with the corresponding session teardown provided by UNBIND_S.

Directory read operations include COMPARE_S, which tests whether a supplied attribute value matches an entry; SEARCH_S and SEARCH_ST, which execute searches against the directory; and the traversal functions FIRST_ENTRY, NEXT_ENTRY and COUNT_ENTRIES for iterating result sets. Attribute access is served by FIRST_ATTRIBUTE, NEXT_ATTRIBUTE, GET_DN and the value-retrieval family GET_VALUES, GET_VALUES_LEN and GET_VALUES_BLOB. Directory modification is supported by DELETE_S, DELETE and MODRDN2_S. Version compatibility of the calling interface is verified through CHECK_INTERFACE_VERSION.

Tables Accessed

The ETRM metadata records no application tables accessed directly through APPS synonyms. This is consistent with the package's design: DBMS_LDAP communicates with the directory server over the network via the DBMS_LDAP_API_FFI foreign function interface rather than through relational tables. Its documented dependencies are on DBMS_LDAP_API_FFI, DBMS_SYS_ERROR, PLITBLM and STANDARD, all owned by SYS. Persistent state is therefore not maintained in the database through this package.

Usage Notes

In an EBS 12.1.1 or 12.2.2 instance, DBMS_LDAP is typically invoked indirectly rather than by end-user forms. It underpins the OID/OAM integration used for SSO and for the synchronisation of FND_USER records with the enterprise directory. Concurrent programs and custom PL/SQL routines that provision, validate or de-provision directory accounts call the package to bind, search and modify entries. Customisations should observe the documented procedure names and semantics and avoid assumptions about internal parameter lists, which are not published in the ETRM metadata. Because the package is owned by SYS and validated as VALID, direct modification is not supported; any issues should be addressed through supported patching.