Hi Everyone,
I am working on APEX Application (5.0) and Oracle 11g. I am working on a task to retrieve Full Name of user by providing GUID (which is stored in table) using DBMS_LDAP package . I was able to do the reverse but not this. The GUID that is stored in table is retrieved by using DBMS_LDAP.GET_VALUES_LEN.
I have tried few options to search and for converting GUID stored in table into Binary like cast to raw and then to binary using user defined function etc. I have also defined DBMS_LDAP.BINVAL_COLLECTION variable and assigned GUID to it. But the LDAP search for GUID, always results in Invalid LDAP message.
Can someone please let me know if there is a built in function that I can use to convert GUID string representation to the format required by LDAP or anyone have any ideas in performing this?
Please let me know if my question is not clear.
Thanks
Madhuri