Oracle APEX - grabbing script output

Question

Does APEX make it possible to call a script using dbms_scheduler, utl_file or other and grab it's output?

The goal is to pass a command to an external API and show a popup either if an exception is generated or a sucess message is received.

Thanks

Answer 1

Assuming that the script is a file on the database server's operating system, you should be able to invoke the script from APEX using either DBMS_SCHEDULER or via a Java stored procedure. Personally, I'd tend to use the Java stored procedure approach just because that's what I've used in the past but it's solely a matter of personal preference.