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 -> Problem getting shell variable under NT

Problem getting shell variable under NT

From: Romain SUAU <romain.suau_at_axa.com>
Date: 2000/04/26
Message-ID: <3906B86C.9B00E3E3@axa.com>#1/1

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

Original text of this message

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