Hello,
I have the below query to extract a given user's manager name from people.oracle.com
SELECT
REPLACE(LOWER(SUBSTR(VAL,4,INSTR(VAL,',')-4)),'_','.')||'@oracle.com'
FROM
TABLE
( apex_ldap.search(
p_host => 'ldap.oracle.com',
p_search_base => 'dc=oracle,dc=com',
p_search_filter=>'mail='||apex_escape.ldap_search_filter(:APP_USER),
p_attribute_names => 'manager')
);
In the p_attribute_name, I wish to extract the country to which that :app_user belongs to. is this possible?
Thanks in advance.