Re: newbie needs help running old oracle 8i code. procedure? function?

Noel wrote:

<snip>

To add to what Noel posted.

Most likely you want to redirect this to a file. In the script where this anonymous block resides, add the following lines,

set serverout on size 1000000
set echo off
set verify off
set heading off
set termout off
set trimspool on

spool yourfile.txt
-- Your code starts here
declare
...
begin
...
end;
/

-- Your code ends here
spool off

Regards
/Rauf
Received on Tue Jan 04 2005 - 11:28:57 CST