3 Replies Latest reply: Feb 4, 2009 1:21 AM by 21205 RSS

    How to spool DBMS_OUTPUT.PUT_LINE from SqlPlus?

    485654
      Hi,

      i have a stored procedure test:
      procedure test is
      begin
      dbms_output.put_line('Test');
      dbms_output.put_line('Test2');
      dbms_output.put_line('Test3');
      dbms_output.put_line('Test4');
      dbms_output.put_line('Test5');
      end;

      I start the stored procedure out of sqlplus:
      spool C:\Temp\test.spl;
      exec test;
      commit;
      spool off;
      exit;

      My problem is no Test or Test2 appeared in the spool file.
      What should i do?

      thanks a lot