Sql script to spool to file on unix box
701029May 12 2009 — edited May 13 2009Hi,
I have a script which executes a stored procedure from my oracle database and spools the results to a file. Now I want to spool the files to a unix file path. I'm executing the script using TOAD. How do I specify the unix file path? Or is there an alternative way to do this?
Here is the script:
set linesize 512
set colsep ""
set pagesize 0
set newpage none
set feedback off
set termout off
set recsep off
set sqlprompt ""
set heading off
set echo off
set serveroutput on
set trimspool on
exec DBMS_OUTPUT.enable(10000);
spool /u02/TEST/test.LST
exec generate_test;
spool off
quit