dbms_ldap

I am hitting ora-31202 Size limit exceeded error when walking the
whole tree. I need all records (few thousand) and you get this error
if you try to retrieve more than 1000 entries at a time it seems.

I have RTFM'd, STFM'd, SFTW'd, SAT'd and Googling again but wanted to
find out if anyone know how to retrieve say 500 rows at a time so
MS-AD doesn't croak ??

Sample code on how to limit the rows (restart where we left) will be
most welcome. I am getting error when I call the function
dbms_ldap.search_s () ...

 -- issue the search
 my_attrs(1) := '*'; -- retrieve all attributes
 retval := DBMS_LDAP.search_s(my_session, ldap_base,
DBMS_LDAP.SCOPE_SUBTREE, 'objectclass=*', my_attrs, 0, my_message);

TIA
Raj
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l

Other related posts: