oracle apex part4: configuring ldap as authenticator and some troubleshooting

[@IB-fz2oq]

Thank you, I upgraded apex from 19 to 20 but no guide is talking about updating the permissions. Only this video helped me

[@edwardohwat7408]

You saved my day :) After moving database I was trying to test LDAP connection, and it failed. It turns out that I missed ACLs . Solved with your video.

[@TramoTech]

I’m glad it helped

[@baiie1]

Thanks it works for me too

[@omatayoholder3349]

Hello, I made the necessary changes that is needed from your video after watching it again but now "simple_bind_s has the wrong number or types of arguments."

[@TramoTech]

Hi, can you post the block your are using and oracle version?

[@omatayoholder3349]

The data represents a test environment.

[@omatayoholder3349]

@@TramoTech Error report - ORA-06550: line 14, column 13: PLS-00306: wrong number or types of arguments in call to 'SIMPLE_BIND_S' ORA-06550: line 14, column 1: PL/SQL: Statement ignored 06550. 00000 - "line %s, column %s: %s" *Cause: Usually a PL/SQL compilation error. *Action:

[@omatayoholder3349]

Where do I need to run the scripts that rectified the issue? I am using sqldeveloper

[@TramoTech]

any client will do the work.

[@VincenzoSozio]

which is the name of the software you use to do queries? it seems like an alternative to sqldeveloper

[@TramoTech]

PL/SQL Developer: www.allroundautomations.com It’s much better than sql developer, however, it is not free

[@VincenzoSozio]

@@TramoTech ok, tanks for the quick answer!

[@fabianoteixeira9259]

May you Help us about LDAP SSL?

[@lulis9817]

Ahmed can you help with the solution of same in this video but with a SSL LDAP?

[@omatayoholder3349]

The script is not present.

[@TramoTech]

DECLARE l_ldap_host VARCHAR2(100) := '192.168.178.78'; l_ldap_port NUMBER := 389; l_ldap_user VARCHAR2(100) = *cn=afikri, ou=Peole,dc=ksirisoft,dc=de'; l_ldap_passwd VARCHAR2(100) := 'afikri'; l_session RAW(32); l_retval NUMBER; BEGIN l_session := DBMS_LDAP.init(hostname => l_ldap_host, portnum =>l_ldap_port); l_retval := DBMS_LDAP.simple_bind_s(id => l_session, dn => l_ldap_user, passwd =>l_ldap_passwd); dbms_output.put_line(l_retval); END; You need to adjust your ldap information

[@omatayoholder3349]

Thank you for the info. I'm trying to run this in Sqldeveloper using different tabs like you did but can't. Also, is there anything else I need to do to run this is sqldevloper?

[@omatayoholder3349]

I'm extremely new to implementing LDAP, hence the request to know exactly how to do this.

[@omatayoholder3349]

@@TramoTech this is the error I received: Error report - ORA-06550: line 11, column 15: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 11, column 1: PL/SQL: Statement ignored ORA-06550: line 14, column 23: PLS-00302: component 'SIMPLE_BING_S' must be declared ORA-06550: line 14, column 1: PL/SQL: Statement ignored 06550. 00000 - "line %s, column %s: %s" *Cause: Usually a PL/SQL compilation error. *Action: