3 Replies Latest reply on Apr 22, 2013 8:49 PM by gaverill

    Getting objectGUID from LDAP to store in RAW16

      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?