How to get dbms_output to print line before the end of the procedure?

begin   dbms_output.put_line('Kilroy1');   dbms_lock.sleep(1);   dbms_output.put_line('Kilroy2');   dbms_lock.sleep(1);   dbms_output.put_line('Kilroy3');   dbms_lock.sleep(1);   dbms_output.put_line('Kilroy4');   dbms_lock.sleep(1);   dbms_output.put_line('Kilroy5');   dbms_lock.sleep(1); end; / You wait five seconds, then get the output. This is the way it works with dbms_output. Now I try a new trick The output does not wait the end. There was a trick I wrote in 2007 using utl_file, but it was […]

multiconsumer Queue with an Oracle Type from Java

You have a multi consumer queue with a user defined type CREATE TYPE topic_message AS OBJECT(Subject VARCHAR2(30),Text VARCHAR2(80)) / BEGIN   dbms_aqadm.create_queue_table(     'topic_queue_table',     'topic_message',     Multiple_consumers=>TRUE);   dbms_aqadm.create_queue(     'toy_topic',     'topic_queue_table');   dbms_aqadm.start_queue(     'toy_topic'); END; / You create the corresponding java class with JPublisher (check the documentation of Database JPublisher User’s Guide 12c Release 1 (12.1) from which I took […]

Advanced Queuing hello world

First for those who are looking for the difference between Queuing, Advanced Queuing (AQ) and Streams Advanced Queuing, there is none. There is no Beginner Queuing and Advanced Queuing was renamed to Streams advanced queuing when streams was popular and renamed back to Advanced Queuing was streams was deprecated. I am the provider, I give […]

Oracle Streams

If you have a datawarehouse and the data are getting to big for a full duplicate or tablespace transport, if you want to experience more about Streams or simply if you are in San Francisco and wants some distraction on Thursday after at 1pm, do not miss Chen session Oracle Streams – Live Demo Oracle […]