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!

Using SQL Statement to SET VALUE.

Eslam_ElbyalyJul 3 2022 — edited Jul 5 2022

Hi. I am using Oracle APEX 22.1.1.
I have two items P1_PATIENT_NAME which is a text field with autocomplete and P1_PATIENT_ID. I created an onChange dynamic action on P1_PATIENT_NAME to get the ID of the name entered by the user (not the contrary). P1_PATIENT_NAME is based on a unique column. The DA is of type "set value" and "set type" is "SQL Statement". The query is...
"select id from patient where name = :P1_PATIENT_NAME and doctor_id = 1". The query retrieves data in "SQL Commands". I tried retrieving a static value from dual like "select 22 from dual" and it did not work too. Affected elements = P1_PATIENT_ID. Page items to submit = P1_PATIENT_NAME. Am I missing something here?

This post has been answered by Eslam_Elbyaly on Jul 5 2022
Jump to Answer
Comments
Post Details
Added on Jul 3 2022
5 comments
1,861 views