Re: spool file name question

Contrary to the other post,

the best method to do this
is to include
define fnam = '&1'
spool &fnam

This will also make your code more readable.

Regards,

Sybrand Bakker, Oracle DBA

<kal121_at_my-deja.com> wrote in message news:8qu2c1$t14$1_at_nnrp1.deja.com...
> I'm trying to create a name for a spool file on the fly. &1 is a
> parameter I pass to this script. In the script, I build up the spool
> file name as follows:
>
> spool $SCRIPTS/ddl/'&1'_utl_recreate.sql
>
> This works ok, the file name ends up looking like this:
>
> 'dev1'_utl_create.sql
>
> If I don't put the single quotes around &1, it assumes it is
> interactive waits for user input. This I don't want. Is there a better
> way of doing this?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Sep 28 2000 - 00:50:56 CDT