Skip to Main Content

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!

Extracting OBJECTGUID using DBMS_LDAP package

991530Jan 15 2014 — edited Jan 21 2014

Hi,

My final goal of this exercise is to search a LDAP for an objectGUID and get the sAMAccountName of the user.

But to get the things started I'm trying the easier way and doing the reverse..

But when I extract objectGUID by searching for sAMAccountName in LDAP - I get the objectguid in the following two formats.

1. utl.cast_to_raw(substr(temp_vals(i),1,200)): 7E0C3F3F3F3F3F31333F783F

2. substr(temp_vals(i),1,200) : ~ ?????13?x?


But I would like to extract the GUID in the escaped format \7e\0c\3f\3f.................... format and which is 48 characters long. Can someone point me in the right direction as to how I can achieve my result both ways.??


Thanks in Advance


Any Pointers will be appreciated!!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2014
Added on Jan 15 2014
12 comments
1,271 views