dbms_ldap

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 27 Apr 2006 15:56:33 -0400
Message-ID: <9177895d0604271256s52cce410y6e4777ff2cbdcfa6@mail.gmail.com>

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 Received on Thu Apr 27 2006 - 14:56:33 CDT