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;
