开发者

Oracle APEX - grabbing script output

开发者 https://www.devze.com 2023-02-12 12:48 出处:网络
Does APEX make it possibl开发者_高级运维e to call a script using dbms_scheduler, utl_file or other

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号