Hi,
I have the following code:
Executing this code via Run Scripts asks for a value for spooldestination, even though there's a column declaration. This code does execute as intended in the old Oracle SQL Developer.
UPDATE - actual code:
DEFINE release_number = "'SAHA10405'"
WHENEVER SQLERROR EXIT 1
SET serveroutput ON SIZE unlimited echo OFF LINESIZE 32767 PAGES 200 TRIMSPOOL ON TRIMOUT OFF WRAP OFF FEEDBACK OFF VERIFY OFF
column spool_destination noprint new_value spooldestination
SELECT &release_number||'_'||sys_context('userenv','instance_name')||'_'
||to_char(SYSDATE,'YYYYMMDD"T"HH24MISS')||'.log' AS spool_destination
FROM dual;
spool &spooldestination
SET DEFINE OFF FEEDBACK ON