Identity Management (MOSC)

MOSC Banner

DBMS_LDAP - : LDAP client/server error: Sizelimit exceeded. Issue

edited Mar 17, 2015 10:01AM in Identity Management (MOSC) 3 commentsAnswered
Hi,

I was able to query for a specific user from Active directory using the below filter. But if I search for all users then it throws me this error:

ORA-31202: DBMS_LDAP: LDAP client/server error: Sizelimit exceeded.

The filter I used is:

filter=>
'(&(sAMAccountName=abc)(objectClass=user))' where I am selecting just one user with the name as 'abc'

If I modify the filter to
'(&(sAMAccountName=*)(objectClass=user))' then it throws the sizelimit exceeded error. Is there a way to avoid this error ?

Full function of the DBMS_LDAP package is below:

DBMS_LDAP.search_s(ld=>l_session,base=>l_ldap_base,scope=>DBMS_LDAP.SCOPE_SUBTREE,filter=>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center