Looking for ideas...ways to run a .sql in Oracle ATP database from PL/SQL or trigger.

From: Ethan Post <post.ethan_at_gmail.com>
Date: Wed, 24 Jun 2020 16:14:10 -0500
Message-ID: <CAMNhnU2Y2xz2JordZiW=8YzhC06TdyyNxJOtYjpGhohwbQQm9w_at_mail.gmail.com>

I was hopeful I could use DBMS_SCHEDULER for this. Not sure, credentials are the main issue I think.

I could write scripts I want to run to a table and have an external server checking for new records and running the .sql from another host.

Not sure if a shared file system is possible. I write an entry to a log on a shared file system and another server is monitoring same file system and runs script when commanded.

How would you accomplish this task?

Ultimately I love .sql scripts for some things and don't want to port them to PL/SQL. I need to be able to run, get output and save, email...this needs to happen in response to some event within the database.

Thanks!
Ethan

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 24 2020 - 23:14:10 CEST