So I'm getting value of 0 for RETVAL..does that mean it has made a connection or not? The DN is correct and the l_session is a valid Hex so it appears to be valid.
retval := dbms_ldap.SIMPLE_BIND_S( ld => l_session
, dn => 'uid=ZZXX,ou=XX,dc=XX,dc=XX'
, passwd => ldap_user_pw);