Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: spool file name question
Nope, that doesn't work either. It still prompts for user input.
In article <8qvuib$bm4$1_at_nnrp1.deja.com>,
kal121_at_my-deja.com wrote:
> define fnam = $SCRIPTS/ddl/'&1'_utl_recreate.sql
> spool &fnam
>
> Still results in the same problem. The output file is still named:
>
> 'dev1'_utl_recreate.sql
>
> And if you take the ' ' off, it prompts you for user input.
>
> In article <970120306.14621.2.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > 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.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Sep 28 2000 - 15:49:20 CDT