how to use variable in Spool
how do I pull a sequence number from the database and use it in a sqlplus spool filename...
this is running as: sqlplus user/pass@sid@c:\file.sql
example of the file:
BEGIN
declare
V_E_NUMBER varchar2(7);
begin
SeLECT 'E'||lpad(RWP.E_NUMBER_seq.NEXTVAL,6,'0') INTO V_E_NUMBER FROM DUAL ;
end;
end;
SeLECT 'E'||lpad(RWP.E_NUMBER_seq.CURRVAL,6,'0') INTO V_E_NUMBER FROM DUAL ;
set echo off
SET HEADING OFF
SET LINESIZE 430
set verify off
SET PAGESIZE 0
SET TRIMSPOOL ON
SET timing OFF
SET termout ON
SET feedback OFF
spool d:\securedASP\CORE.BU34500.AR.'||:V_E_NUMBER||'.RECEIVD
select * from table;
spool off