Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LDAP Username Edit Function

User_C585VDec 16 2022 — edited Dec 20 2022

Hi,
I want to replace username before LDAP authentication starts.
I have created a function:
create or replace function "GET_CN_FROM_LOGIN"
(p_username in VARCHAR2)
return VARCHAR2
is username VARCHAR2(256);
begin
select cn
into username
from users
where p_username = login and logon_privilage = 1;
return username;
end;

and then I have referenced it in 'LDAP Username Edit Function' field like this:
return get_cn_from_login(p_username => :USERNAME);
When I test it via "Test LDAP Login" in Authentication Scheme it's working but when i try to log into my app it doesn't work. Says:
Error processing edit LDAP user function.

What's wrong?
Bart

Comments
Post Details
Added on Dec 16 2022
0 comments
380 views