Hi, I was figuring out this issue which makes use of the DBMS_LDAP PL/SQL library.
Some of the local variables in the function from Roel Hartman have a data type of DBMS_LDAP.STRING_COLLECTION.
I'm troubleshooting the function for our specific use-case and I'm running into an issue when debugging. In particular, I am wanting to view the values of l_vals(i) as it is looping in the innermost loop. However, they are showing up as NULL:
But I know that this code is working mostly reliably - as a side note, the particular issue I am running into is the line highlighted in the image above, l_ok := instr(upper(l_vals(i)), upper(p_auth_group)) > 0;, when I have the input “Domain Users” for p_auth_group. For whatever reason, it is saying that the user is not in that particular group. I thought it might be due to the space in “Domain Users” but if I do a plain instr(upper('Domain Users'), upper('Domain Users')) > 0 I get true (unlike the function, which is giving me false, but it should give me true).
On the debugging front, I noticed l_vals is null and wondered if I am missing something? Or, possibly, is there an issue with the debugging tool in VS Code? (This post is about the NULL l_vals, not the bug / issue I am running into.)