Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Passing argument from plus33.

Re: Passing argument from plus33.

From: Rauno Seppanen <rauno.seppanen_at_nbs.fi>
Date: Mon, 13 Sep 1999 10:17:26 GMT
Message-ID: <37DCCF72.A810D967@nbs.fi>


screwbai_at_my-deja.com wrote:

> I am running test.sql. I want it to spool the output to the directoy
> that I have as argument 1 in the pluss33 line. However it is unable to
> pick up the $1 variable inside the test.sql. Is it possible. What do I
> have to do. Thanks.
>
> plus33 -S login/passwd_at_dbs @test.sql E:/prod
> ^
> |
> test.sql: |
> |
> |---------------------------------|
> |
> SPOOL $1/run_qabatch.sh
>

You should try following changes:

plus33 -S login/passwd_at_dbs @test.sql E:\prod (at least in NT E:/prod doesn't work but E:\prod does)

and
SPOOL &1/run_qabatch.sh

Rauno Received on Mon Sep 13 1999 - 05:17:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US