Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

DBMS_LDAP - Accessing LDAP From PL/SQL - Use the DBMS_LDAP package to query and modify LDAP entries from PL/SQL.



RT WA Aus said...

Good, useful example - excellent starting point to extend. We found it was failing initially but think this was due to the volume or data types being brought back from ADS. Once we restricted the volume of data and/or restricted to selected attributes it worked well.
Thanks

RA said...

Hi RT WA,

Could you please post or send your solution on how to handle the huge volume. I am bumping into "ORA-31202: DBMS_LDAP: LDAP client/server error: Sizelimit exceeded" error.

I truly appreciate if you could mail your solution on volume handling to angani@gmail.com

Regards
Raju

Amardeep Singh said...

We can put filters in search to make search fast.Pre-requisite : If you are using custom Attributes in filter then it must be indexed in OID.
If you attempt to perform a search with a non-indexed attribute specified as a required attribute, the server will return a "LDAP client/server error: DSA is unwilling to perform. Function Not Implemented" error.

Value for Filters(variable l_ filter in my case ) can be as follows :
1. No filter then use : 'objectclass=*'
2. Logical operator : if my users are distinguished by having objectClass attributesequal to 'person' and mycustomattr=Yes ), this is how I would match for it:

'(&(objectClass=person)(mycustomattr=Yes))'

3. The pipe symbol '|' denotes 'OR' :
'(|(objectClass=person)(mycustomattr=Yes))'

4. In case of three attributes :
'(&(&(objectClass=user)(objectClass=top))(objectClass=person))'

5. Not operator :
'&(!(procsd_ind=Y))(objectclass=*)'

lah said...

when i tried your code all i can display is a number .how can i display all the attributes of a user?

Tim... said...

Hi.

That will all be down to credential and search strings. Nothing I can no about that.

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired