Oracle Application Express (MOSC)

MOSC Banner

Two SelectLists the second one dependent to the first one

edited Feb 9, 2022 11:32AM in Oracle Application Express (MOSC) 1 commentAnswered ✓

Hi

I need your support with a problem I faced in APEX.

 I have a form with 2 SelectLists:

  • The first one P2_DB contains name of my databases and the source comes from simple query

select d.dbid, d.dbid from pt_database where ....

It works and all expected data are displayed correctly.

  • The second one P2_USERNAME, should list all logins/usernames belongs to database pointed in the first SelectList. It is kind of slave to the first SelectList. And now my problem starts. thought i was enough to add as a source similiar query , something like :

SELECT dbuser, username FROM PT_USER_PERMISSION  where dbid=(:P2_DB)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center