1

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

Joao Figueiredo
  • 3,120
  • 3
  • 31
  • 40

1 Answers1

3

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.

Justin Cave
  • 227,342
  • 24
  • 367
  • 384