My Oracle Support Banner

DBMS_LDAP Against MS AD Returning More than a Thousand (> 1000) Entries Fails with: Ora-31202 Ldap Error: Sizelimit Exceeded (Doc ID 292932.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Internet Directory - Version 9.0.4 and later
Information in this document applies to any platform.


When executing DBMS_LDAP.search_s against Microsoft Active Directory (MS AD) which returns more than 1000 entries, you get the error messages:

ORA-31202: DBMS_LDAP: LDAP client/server error: Sizelimit exceeded
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1342
ORA-06512: at "SYS.DBMS_LDAP", line 241





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.