Database Administration (MOSC)

MOSC Banner

Filewatcher is not working

edited Sep 17, 2013 1:41AM in Database Administration (MOSC) 5 commentsAnswered ✓
 Hi Experts,
I am testing file watcher and i could not see any rows in the table


 Steps followed

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center