SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_ldap: LDAP client/server error: Bad search filter

932936Nov 7 2012 — edited Nov 8 2012

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

All,

I'm trying to do a recursive search of all ReportTos and their ReportTos' ReportTos using DBMS_LDAP. So far, everything is going good. I have one function that takes a sAMAccountName and gets ReportTos from that, and one function that takes DNs and recursively searches ReportTos by DN.

The issue I'm comming up with is I have one DN:
CN=SomeBloatsDistinguishedName\, (,OU=GeneralUsers,OU=MyCompanyUsers,DC=SomeGeo,DC=MyCompany,DC=com

Naturally, because of the funny paranthesis, it's throwing an error when I try a searched by:
distinguishedname='CN=SomeBloatsDistinguishedName\, (,OU=GeneralUsers,OU=MyCompanyUsers,DC=SomeGeo,DC=MyCompany,DC=com'

Any ideas how I can work around this without skipping over this user?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2012

Added on Nov 7 2012

2 comments

547 views