Application Express#

LDAP authentication scheme calls wwv_flow_custom_auth_ldap.authenticate. According to Oracle, this is not an official API and they may revoke the grant in future versions, but in Application Express 4.1, you can for test LDAP auth in SQL workshop with:

declare
    l_status boolean;
begin
    l_status := wwv_flow_custom_auth_ldap.authenticate (
                                 p_ldap_host     => ...host...,
                                 p_ldap_port     => ...port...,
                                 p_dn            => ...dn_string...,
                                 p_search_filter => ...search_filter...,
                                 p_password      => ...password...,
                                 p_use_ssl       => ...ssl_mode... (Y for SSL, A for SSL with authentication, N for no SSL),
                                 p_use_exact_dn  => ...use_exact_dn... (Y or N) );
    dbms_output.put_line(case when l_status then 'authenticated' else 'auth error' end);
end;

Oracle SQL To Access LDAP#

Show how to use Oracle SQL To Access LDAP

More Information#

There might be more information for this subject on one of the following:

• Oracle SQL To Access LDAP