You have some operatingsystem scripts on one server that need to run in response to certain changes in data in your Oracle Database…

You have some operatingsystem scripts on one server that need to run in response to certain
changes in data in your Oracle Database.The mostefficient way to implement this with Oracle
Database 11g would be:

You have some operatingsystem scripts on one server that need to run in response to certain
changes in data in your Oracle Database.The mostefficient way to implement this with Oracle
Database 11g would be:

A.
Write a PL/SQL routine that connects to the remote server and calls the script.

B.
Create a script on the database server to perform the remote action and thatscript from
adatabase trigger.

C.
Modify the script on the remote server to periodically chock for these data change in your
Oracle database.

D.
Install an Oracle Scheduler Agent on the remote server and create job to be called from Oracle
scheduler in response to a database server event.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *