Filewatcher is not working
Hi Experts,
Steps followed
I am testing file watcher and i could not see any rows in the table
1. create user test1 and grant dba to test1
2. conn test1/oracle
BEGIN
DBMS_SCHEDULER.CREATE_CREDENTIAL('WATCH_CREDENTIAL', 'test1', 'oracle');
END;
/
3.
begin
DBMS_SCHEDULER.CREATE_FILE_WATCHER (file_watcher_name=>'TEST_FILE_WATCHER',directory_path=>'/refresh/home/expdir',file_name=>'*.abc',credential_name=>'WATCH_CREDENTIAL',destination=>null,enabled=>false);
end;
/
4. create table fw_results_log(file_timestamp timestamp with time zone, directory_path varchar2(4000), file_size number);
5. create or replace procedure test_procedure
(fw_result in sys.scheduler_filewatcher_result) as
0