Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

give a spool parameter

Tricampeon_1981Nov 30 2018 — edited Nov 30 2018

Hello good day

friends I need to pass the path to create the file as a parameter but it does not work

SET ESCAPE OFF

SET SERVEROUTPUT ON SIZE UNLIMITED

SET PAGESIZE 0

SET ECHO OFF

SET FEEDBACK OFF

SET LINESIZE 2000

SET VERIFY OFF

SET HEAD OFF

SET TRIMSPOOL ON

SET TERMOUT OFF

SET TRIM ON

SET TERM OFF

SPOOL &&1;

--SPOOL c:/  

begin

select sysdate fomr dual

end

/

spool off

This post has been answered by jaramill on Nov 30 2018
Jump to Answer
Comments
Post Details
Added on Nov 30 2018
17 comments
1,854 views