APEX, ORDS & the Oracle Database
I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.
Markdown supported · ⌘↵ to post
Hello. Thanks! Your post was really helpful!
I have a question. In my application there is LOV item with the option 'Search as you type' selected. I have a button (disabled) to add a new entry, I would like this button to be enable when the result of the search returns no value. I've tried with JS and with DA, but I couldn't achieve this behavior. Do you have any idea how can I do that?
Jochen Zehe
Improvement 2: Ability to pass in parameters from the calling page.
Jon Dixon You could use Source Type = "Function Returning SQL" instead of a SQL Query.
return lov.get_emp_list ('P' || :APP_PAGE_ID || '_DEPT_ID');"