hi tim
its not working in that way also as iam using oracle 9i
i write this in glogin.sql file:
column l_date new_value l_date noprint
select to_char(sysdate,'DDMONYYYY') l_date from dual;
spool c:\sqllog\log_&&l_date append
and when i login to my sql it gives following error:
Illegal spool file name: "c:\sqllog\log_14FEB2006 append" (bad character: ' ')

is there any other way. i don't want to overwrite the previous data in my spool file that was created very first time i logged to my SQL.

thanx