This discussion is archived
3 Replies Latest reply: Apr 22, 2013 1:49 PM by gaverill RSS

Getting objectGUID from LDAP to store in RAW16

724687 Newbie
Currently Being Moderated
I currently have a procedure to read out our LDAP server to store employee data. We'd like to use the objectGUID from the LDAP to be stored in our database. When I capture that attribute, the DBMS_LDAP.get_values converts it to a string. If I convert it back to raw using UTL_RAW.CAST_TO_RAW, I can store it as a RAW, but it's not the same as in the LDAP anymore.

For example:
1. In LDAP: 1A 0D 46 A1 65 D2 B2 42 BA 46 B7 03 1E CB E2 6C

(or in some LDAP browsers displayed as {A1460D1A-D265-42B2-BA46-B7031ECBE26C} . I have no clue what kind of forma this is?)

2. The string DBMS_LDAP.get_values reads out: F�eҲB�F��l (If I export it from an LDAP browser, I get F¡eÒ²BºF·Ëâl)
3. The result from UTL_RAW.CAST_TO_RAW: 1A0D46EFBFBD65D2B242EFBFBD46EFBFBD031EEFBFBD6C

How can I solve it, so I get the exact RAW value that is in the LDAP, in the database?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points