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!

Query an APEX Rest Data Source directly with PL/SQL?

Joe KerrMar 20 2024 — edited Mar 20 2024

Context: Multiple APEX (23.2) REST Data Sources are defined with parameters such as employer ID and employee ID. The external REST Data Sources are not Oracle based.

Objective: Query the REST Data Sources using PL/SQL while varying employer and employee ID parameter values. For example, Loop through a list of employees and query their address information in order to perform a data load process. Executing the PL/SQL procedure either as an APEX automation or Dynamic Action would be fine.

Question: Can/how do I query the REST Data Sources?

Thanks
Joe

This post has been answered by InoL on Mar 20 2024
Jump to Answer
Comments
Post Details
Added on Mar 20 2024
4 comments
2,314 views