I am trying to get a file_watcher scheduler to work. I am using the instructions from
https://www.mikesdatabaseplace.com/databases/oracle/oracle-database-features/oracle-scheduler-dbms_scheduler/oracle-file-watcher
As I am working on an Autonomous Database (in the cloud) I cannot create new directories and I am using the default DATA_PUMP directory. I am using the path of this DATA_PUMP directory instead of the directory as mentioned in the article above.
BEGIN
DBMS_SCHEDULER.create_file_watcher(
file_watcher_name => 'myfilewatcher',
directory_path => '/u03/dbfs/08EFD3E75DF777BEE063EB10000A59C9/data/dpdump',
…..
END;
Using:
BEGIN
DBMS_CLOUD.EXPORT_DATA(
file_uri_list => 'DATA_PUMP_DIR:eodxxxx.csv',
format => JSON_OBJECT('type' value 'csv'),
query => 'SELECT * FROM dual'
);
END;
I can manage to create a new file in the DATA_PUMP directory (and can verify this via SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
But then nothing happens.
When querying :
SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS where job_name='FILE_WATCHER'
I see a record with status FAILED, errors: "ORA-06576: not a valid function or procedure name"
But the myfilewatcher_proc procedure I am calling does exist and is valid and runs without errors when I execute it via Begin myfilewatcher_proc; end;
How can I debug this further?