DBMS_LDAP unable to use BITWISE AND/OR filter to ignore disabled accounts.
I am trying to write a PL/SQL code to fetch AD accounts, except disabled one.
I was referring BITWISE filter given in Note.1227144.1
(&(objectCategory=person)(objectClass=user)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))
Somehow this filter is not working and I am not getting any output from my query.
can somebody help me fix this issue.
{code}
declarel_retval PLS_INTEGER;l_session dbms_ldap.SESSION;l_attrs dbms_ldap.string_collection;l_message dbms_ldap.message;l_entry dbms_ldap.message;l_attr_name VARCHAR2(256);l_ber_element dbms_ldap.ber_element;l_vals dbms_ldap.string_collection;l_host varchar2