Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem getting shell variable under NT
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 CDT