Re: Problem getting shell variable under NT

Maybe you can create a temporary *.bat or *.cmd file containing set commands for environment variables?

Martin

Romain SUAU wrote:
>
> Hello,
>
> I'm trying to get back values set into shell scripts under sql command
> files launched by these scripts.
> For example, in a
>
> test.cmd
> #####################################
> REM This is the command file
> SET USER=username
> SET PASS=password
> SET REP=C:\TEST
> svrmgr23.exe < c:\start.sql
> #####################################
>
> start.sql
> #####################################
> # This is the sql file
>
> CONNECT %user%/%PASS%
> STARTUP PFILE=%REP%\init.ora
> EXIT
> #####################################
>
> This method does not work at all... I used to develop scripts under Unix
> where I could use ${...} for calling back shell variable values. I use
> Oracle under NT now and don't know how to do this...
>
> If you can send a copy of your response to rsuau_at_free.fr I would
> appreciate it a lot.
>
> Thanks for any help,
> Romain
Received on Wed Apr 26 2000 - 00:00:00 CEST