Fear No SQL
I’ve found myself needing to search LDAP data more often and each time I do it’s been sort of obnoxious to have to rewrite variations of mostly similar DBMS_LDAP routines. Frequently I then need to use that data in a SQL query of some sort to combine it with other data found in one or…
I’ve made several updates to my package for maintaining name resolution entries in LDAP. The search calls have been modified to be both more accurate and more efficient. Previously I would use the one-level search under the OracleContext path whether the search was for a specific entry or all of them. Now, if you search…
Table of Contents Introduction Establishing a Connection Searching Hierarchical Data Browsing Attributes Timeouts Modifying Data (this page) Modifying data in the LDAP hierarchy The DBMS_LDAP package allows you to write as well as read data from the directory. However, it does not provide an API for manipulating the schemas within the tree. That is, you…
Table of Contents Introduction Establishing a Connection Searching Hierarchical Data Browsing Attributes Timeouts (this page) Modifying Data Timeouts LDAP servers are designed to be fast; but it is still possible for an action to take a long time. A deep sub-tree search with an open search criteria could require from seconds to even minutes to…
Table of Contents Introduction Establishing a Connection Searching Hierarchical Data Browsing Attributes (this page) Timeouts Modifying Data Searching Hierarchical Data with Attributes Returning attributes with search results The examples in the prior chapter use the “1.1” code to return no attributes. In this example we’ll return two of the attributes associated with an entry. Instead…
Table of Contents Introduction Establishing a Connection Searching Hierarchical Data (this page) Browsing Attributes Timeouts Modifying Data Searching Hierarchical Data Once you’ve established a connection, the next thing you’ll probably want to do is start searching for records. Either to pull the data back to a client, or to modify one or more records or…
Table of Contents Introduction Establishing a Connection (this page) Searching Hierarchical Data Browsing Attributes Timeouts Modifying Data Establishing a Connection The DBMS_LDAP.INIT function is used to connect to an LDAP server. On success, the function returns a session handle of DBMS_LDAP.SESSION type. FUNCTION init (hostname IN VARCHAR2, portnum IN PLS_INTEGER ) RETURN SESSION; DBMS_LDAP.PORT is…
Introduction In 9iR1 (9.0.1) Oracle released the first version of DBMS_LDAP. Between then and 18c the package has received a few enhancements including support for BLOBs, Basic Encoding Rules (BER,) and NLS character set conversions. The documentation for the package has alwasy been somewhat terse, especially if you’re unfamiliar with LDAP structures and usage. I’ve…
I let this project sit on the back burners for too many months but tonight finally got around to cleaning it up and getting it out for people to use. Do note, the authentication is a little different and hence, not compatible with prior versions. While I don’t like breaking compatibility, it was a necessary…