Oracle APEX - grabbing script output
Does APEX make it possibl开发者_高级运维e 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
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.
精彩评论