SQL & PL/SQL

Hello,

I was wondering if there was an efficient way to display output data during run-time of a stored procedure/pkg? I use dbms_output.put_line in conjunction with set serveroutput on. While this most certainly displays output to me, it only gets displayed AFTER the code has finished running.

Right now I have a "status" table set up to where I do inserts/updates to it, followed by commits, throughout the pl/sql code. This way I can query the "status" table to see where at in the process the job is currently at. I find this helpful when doing some inserts that consist of several million records.


Anyhow, the question is more of, can I display output DURING the run-time with some special command, instead of having to go make a status table and periodically writing to that table? And, is this good/bad practice to use a table in this manner?