Hi Team,
i have a procedure which basically writes the files in unix server.I put some DBMS_OUTPUT.PUT_LINE messages for debugging purpose.When i am trying to run that procedure wi...
http://www.experts-exchange.com/Database/Oracle/Q_21494134.html
Zones:
OracleDate Answered: 09/13/2005 Grade: B Views: 0
Hi
I run a stored procedure on unix
$ set serveroutput on
exec my procedure_name.proc
PL/SQL procedure successfully completed.
NOW WHERE CAN I THE OUTPUT FILE GENERATED BY THE ABOVE?
Thanks
http://www.experts-exchange.com/Database/Oracle/Q_22852625.html
Zones:
OracleDate Answered: 09/27/2007 Grade: B Views: 5
The following code gives an error after so many iterations:
set serveroutput on
spool craig.txt
declare
v_item char(19);
v_revc char(6);
cursor item_cursor is
select t$sitm
...
http://www.experts-exchange.com/Database/Oracle/Q_11308257.html
Zones:
OracleDate Answered: 09/18/2000 Grade: A Views: 146
Hello Friends,
I run a small SQL block and since that involves a lot of dbms_output.put_line statements and therefore have to run the following set options, before running the block:
set serv...
http://www.experts-exchange.com/Database/Oracle/Q_21334695.html
Zones:
OracleDate Answered: 03/02/2005 Grade: A Views: 42
I'm getting the Oracle error:
ORU-10027: buffer overflow, limit of 20000 bytes
This would most likely fix the problem:
set serveroutput on size 100000
CREATE OR REPLACE PROCEDURE "NSD"....
http://www.experts-exchange.com/Database/Oracle/Q_21773621.html
Zones:
OracleDate Answered: 03/15/2006 Grade: A Views: 45
With SQL*PLus
1. set serveroutput on size 1000000
2. exec <some procedure>;
The output is viewed on the screen
With TOAD
How to get similar results,
http://www.experts-exchange.com/Database/Oracle/3rd_Party_Tools/Q_22064608.html
I have written the following trigger on system event logon.
It is compiled with no errors. But when I am loging into database it is not giving output. Even I have set
set serveroutput on.
Cou...
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_20624107.html
I am trying to do a DBMS_OUTPUT.PUT_LINE command in JDEVELOPER STUDIO 10.1.3.2.0.4066 and I get a Command Completed Successfully, I don't get the actual output. Someone said I need to have SERVERO...
http://www.experts-exchange.com/Database/Oracle/Q_22901839.html
