You cannot concatenate into the variable you DEFINE. Thats why it doesn't append your '.xls' to the filename. Try selecting into it:
Select 'D:\...\cgbill'||&v_date||'.xls' into v_file_name from dual;
|
Results 1 to 10 of 15
Thread: spool..truncate..procedure ????Threaded View
|
Click Here to Expand Forum to Full Width |