Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Streams AQ: waiting for messages in the queue

759325Apr 16 2010 — edited Apr 21 2010
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2010
Added on Apr 16 2010
9 comments
17,559 views