#Filewatcher failed how to#

Yes, I could combine the steps, but (a) this would be more flexible if it works (i.e. Sorry - for some reason I can't reply to your reply, so I'll have to do it this way.ДЎ. What am I missing? I need to get the file-name into the stored procedure, but can't see how it should be done.

#Filewatcher failed how to#

I can't see how to execute code in the File Watcher step, which is (I think) the basic problem since this is where the EVENT_MESSAGE parameter would/should be available. So my first two steps and the rules linking them are defined as follows:ДЄCTION => 'START 'ACS_USAGE_WATCHER_STEP''Д¬ONDITION => ''ACS_USAGE_WATCHER_STEP' COMPLETED',Д¬ONDITION => ''LOAD_ACS_USAGE_STEP' COMPLETED', ORA-21560: argument 7 is null, invalid, or out of range However, I can't work out how to get the EVENT_MESSAGE parameter into the Load_File step so it knows which file to actually load - the second step always shows in the Job Run Details as FAILED:Д¬HAIN_LOG_ID='11592', STEP_NAME='LOAD_ACS_USAGE_STEP', ORA-01024: invalid datatype in OCI call The Chain Job successfully waits until the File Watcher sees the file has arrived, and then everything is triggered correctly according to the Rules. I couldn't see a way to link the File Watcher step to the program, so the first step in the Chain has the file watcher as the queue_spec according to the docs, and the second step refers to the Program (LOADINCOMINGFILE). I disabled the 'LOAD_ACS_watcher_job' and created a Chain. So I want to add another step after the file is loaded, to do the merge. dbms_scheduler.create_job(Д®nabling this job works perfectly - the event_message gives the procedure the file name, and it gets loaded properly. This works fine when the program is used directly as a Job target i.e. Program_action => 'CDA_Load_Incoming_File', The LOADINCOMINGFILE program is defined as dbms_scheduler.create_program( I have a stored procedure: procedure CDA_Load_Incoming_File (payload IN sys.scheduler_filewatcher_result) as Merge the loaded data into an aggregated table.I am trying to make a simple Chain that is supposed to Executive Summary: How do I get the EVENT_MESSAGE parameter from the event raised by the FILE_WATCHER, into a Chain Step?