Calling LDAP from a Stored Procedure

Question

Background

I'm trying to migrate from an LDAP identity store to a database backed implementation. There will be a migration period in which it will be necessary to sync any changes to passwords on the database with the LDAP store.

My question is if its possible to make a LDAP modify call from a stored procedure on the Oracle Database. Ideally the stored procedure would be called based off a trigger on the password field.

Answer 1

PL/SQL programmatic access to LDAP directories is accomplished with the DBMS_LDAP and DBMS_LDAP_UTIL packages. Complete query, search and object modification is supported.