Using Substitution Variables Dynamically in File Names

I'm looking to use a substitution variable in a file name. Here is what I have so far.

column sn new_value company_name noprint select scompanyname into :company_name from tblcompany where ncompanyid = :companyid
spool /home/utils/companyReport/&company_name.&file_time..txt

prompt -- &company_name --;

The variable &company_name doesn't appear to be working. Any help would be appreciated.

Thanks.

Steve Received on Tue Oct 16 2007 - 11:56:46 CDT