1

I have some procedure in PL/SQL like:

set serveroutput on
DECLARE
  p_data          DATE;
  v_line          VARCHAR2(2000);
BEGIN
  v_line := 'START';
  dbms_output.put_line (v_line);

---------- 1 --------------------------
  WRT.TL_XTERN.process(
      p_data_d => p_data_d
  );
  v_line := ' WRT.TL_XTERN.process ended';
  dbms_output.put_line (v_line);

---------- 2 --------------------------   
  WRT.TL_MAP.process(
      p_data_d => p_data_d
  );
  v_line := ' WRT.TL_MAP.process ended';
  dbms_output.put_line (v_line);

  v_line := 'STOP';
  dbms_output.put_line (v_line);      
END;
/

Now, when I run it in sqlplus, all messages appear after both process ended. How can I get each message exactly when it appears in code.

Gadziu
  • 657
  • 7
  • 21

0 Answers0