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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Refresh Select List supported in Apex 19.2?

John like many othersOct 28 2020 — edited Oct 28 2020

Hello
I'm working with Apex 19.2
I have a simple Select List source-based on a SQL using Item values of another region. The Select List has no parent cascading list. The Select List will be filled properly on loading the mask. Depending on the values of the mentioned items (used in SQL of Select List) the list content as such should change. So there is a button next to Select List executing a "Refresh" (provided action) on the Select List (affected items -> select list).
The problem: After pressing the button the select list is empty instead of refreshed. It even keeps empty if the other items (used in the SQL of the Select List source) do not change.
Questions:
Is the internal Refresh action not working with Select List?
If yes: Is there something specific to do/set in order to make it work?
If no: Is there another possibility/solution I can use in order to refresh the Select List adhoc?
Thank you for any hints

Comments

Jan
Not experienced with the windows implementation, only on linux ... but maybe it may help ...
cx_Oracle is only the bridge between python and the oci interfaces of Oracle, an exposure of the c-api's towards python.
On linux you must set the LD_LIBRARY_PATH variable to the location where the oracle client libraries can be found. (typically something linke libclntsh.so.*). So ... I guess that on a windows environment the client dll's should be in the path (%PATH%) ... Hope somebody can confirm or correct this. Maybe it may help ...
1 - 1

Post Details

Added on Oct 28 2020
0 comments
1,001 views