Hi,
I am having problem with dbms_output in the command window. Everytime I call dbms_output.put_line it puts a blank line before
Code Example
SET SERVEROUTPUT ON SIZE 1000000
SET FEEDBACK OFF
SET ECHO OFF
SPOOL d:\temp\test.dat
EXECUTE dbms_output.put_line('0TEST0001');
EXECUTE dbms_output.put_line('0TEST0001');
SPOOL OFF
SET SERVEROUTPUT OFF
Output in command window is :
SQL>
Started spooling to d:\temp\test.dat
0TEST0001
0TEST0001
Stopped spooling to d:\temp\test.dat
SQL>
Content of the file :
0TEST0001
0TEST0001
Works without problem in sql*plus, anyone has this issue?
Version is 7.0.2.1076
I am having problem with dbms_output in the command window. Everytime I call dbms_output.put_line it puts a blank line before
Code Example
SET SERVEROUTPUT ON SIZE 1000000
SET FEEDBACK OFF
SET ECHO OFF
SPOOL d:\temp\test.dat
EXECUTE dbms_output.put_line('0TEST0001');
EXECUTE dbms_output.put_line('0TEST0001');
SPOOL OFF
SET SERVEROUTPUT OFF
Output in command window is :
SQL>
Started spooling to d:\temp\test.dat
0TEST0001
0TEST0001
Stopped spooling to d:\temp\test.dat
SQL>
Content of the file :
0TEST0001
0TEST0001
Works without problem in sql*plus, anyone has this issue?
Version is 7.0.2.1076