This content has been marked as final. Show 3 replies
Hi Kuru,1 person found this helpful
what version of APEX you are using?
You should change DA event to onChange and then use Set Value DA Action or Execute PL/SQL code with defined Page Items to Return (email and phone in your case).
Are you trying to avoid submitting the page?
If submit page is OK, I usually do something like the following:
1) Set the Name field action to "Submit". In the Settings section of the "Name" page item you should see "Submit when Entered pressed". Set this to Yes.
2) Add a page process, On Load - Before Header, to set the e-mail and phone fields equal to whatever is in the database for the given name, conditionally if the name is found in the database.
3) You may need to include a branch back to this page.
When the page reloads, if a name is in the name field, the process should load the e-mail and phone.
Hope this helps,
Hi Marko Goricki,
Thank you for the reply. What i was missing in my logic is that return statement in pl/sql body. instead i was using typical assignment a := :b;
And one more thing i had to do is submitting the name field which is basically used for querying the table.