Streams AQ: waiting for messages in the queue
759325Apr 16 2010 — edited Apr 21 2010Hi,
For some reason, I've to run the owb mapping manually. First I try to run it in this way:
declare
n_result number;
begin
n_result:=dwrr104.wb_rt_api_exec.run_task('LOC_ZONE2_DW','PLSQL','MAP_RMS_CUSTOMER');
dbms_output.put_line('result :='||n_result);
end;
This script just kept running endlessly. I noticed The wait event in database for this session was: "Streams AQ: waiting for messages in the queue"
However, if I run the 'main' function of this mapping directly like this:
declare
-- Non-scalar parameters require additional processing
p_env dw.wb_rt_mapaudit.wb_rt_name_values;
begin
-- Call the function
:result := dw.map_rms_web_ptrackcode.main(p_env => p_env);
end;
it can work without any problem.
Any ideas?
Jeffrey