Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Passing argument from plus33.
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
![]() |
![]() |