Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_LDAP -- SizeLimit exceeded.

User_5L2KOMay 7 2021

dbms_ldap does not seem to support paged results from AD. AD seems to have a query size limit of 1000 records. I am able to fetch results for smaller size filters (839 records) but the objectclass=* returns ORA-31202: DBMS_LDAP: LDAP client/server error: Sizelimit exceeded right away.

Is there any way of fetch all the entries, other than to make a nested for-loop that steps through each letter of the alphabet, creating a common name filtering phrase ?
thanks

Comments
Post Details
Added on May 7 2021
1 comment
793 views