dvsoukup wrote:Correct. As PL/SQL is running in a server process and is not connected to a keyboard and screen and unable to interact with the user. After all, this is client-server and the client process deals with user interaction. Not the server.
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.