Hi,

Can I access environment variables from sqlplus in OS-neutral fashion?

I couldn't find anything in the official documentation, but I came
across a post on experts-exchange that suggested I could access
environment variables in an sqlplus script as follows:

SET FEEDBACK OFF;
@ %TEMP%/gen.sql
@ %TEMP%/gen_ja.sql
SET FEEDBACK ON;

Turns out it works fine on Windows, but Unix requires the traditional
'$...' format.
@ $TEMP/gen.sql

I'd like to keep my scripts OS-neutral and stay away from SED simply
to substitute '$TEMP' with '%TEMP%' and such.

any suggestions?

I'm running 8.1.7

thanks,

bill milbratz

william milbratz wrote:
Hallo Bill,

aren't you asking a bit too much? OS-neutral environment variables? I
thought the environment was part of the OS, but then I have been on
holidays.

Does "@ %TEMP%/gen.sql" work? I thought µicro$oft used backslashes,
but then ...

Maybe I could try to give some serious advice.

Don't use the OS in your scripts: for this specific problem, you could
define "ORACLE_PATH" in the OS, before starting Sqlplus, and add your
temporary directory to it. So your script would work on both Whinedoze
and (Li|U)n(u|i)x.