Spool appending using NEW_VALUE

I'm trying to use NEW_VALUE within a script in Oracle. Run from Red Hat Linux
I need the log generated is: create_table_tags_ddmmyyyyhh24miss.log

clear scr
set serveroutput on
set verify off
set echo off
set feedback off
set trimspool on
def path='PATH_COMPLETE/LOGS'
column tm new_value file_time
select to_char(sysdate,DDMMYYYYHH24MISS') tm from dual;
prompt &file_time
spo &&path./create_table_tags_&file_time..log
--
DECLARE

  v_create VARCHAR2 (10000); 

BEGIN

/* my code */

END;
/

Open in new window



But when I run I see the errors:

SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 16 15:15:36 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SQL>
ERROR:
ORA-01756: quoted string not properly terminated
Enter value for file_time:
SP2-0546: User requested Interrupt or EOF detected.
Enter value for file_time:
SP2-0546: User requested Interrupt or EOF detected.

SQL> Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

Open in new window


Could you help me to find the error, please?

Thanks in advanced!
carlino70Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
First error you are missing a single quote:
select to_char(sysdate,'DDMMYYYYHH24MISS') tm from dual;


See if that fixes the other issues.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
carlino70Author Commented:
Thanks, and apologies for this omission.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.