Hello,
I am new to APEX and I am developing an application to manage Oracle database user accounts. I have a page (8) that has text items for the username and the database name. I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account. I have another button that should:
- get the value of the username - P8_USERNAME
- assign it to an application item - FIND_USER_IN_DB
- redirect to page in application - to page 11
The issue is that FIND_USER_IN_DB does not get populated and page 11 which is a simple report with the following query:
SELECT *
FROM valid_db
WHERE username = :FIND_USER_IN_DB;
How do I accomplish this?
Thanks for your help.
Steve