PL/SQL (MOSC)

MOSC Banner

DBMS_LDAP unable to use BITWISE AND/OR filter to ignore disabled accounts.

edited Jan 21, 2014 2:28PM in PL/SQL (MOSC) 5 commentsAnswered
Hi,

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

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