Can we access the a environment variable in a SQL Script

[oracli]

you can probaly use from your UNIX box:

Make a shell script to generate the SQL code for calling the procedure then execute that SQL code in sqlplus:

make_sql.sh:

#!/bin/bash
echo "
spool proc.log
connect user/password@db
begin
proc($e2DefaultEnv);
end;
spool off
exit
" > test.sql
sqplus /nolog @test.sql

then run the make_sql.sh which will make the SQL script and run it using SQL*Plus. The stored procedure in is called proc in the example. You will have a log of the operation in the proc.log file.