-- Srikanth Madani <[EMAIL PROTECTED]>
When the script exists, this variable will no longer be available.
The variables are part of the currently running program:
int main( int argc, char **argv, char **env )
{ ^^^^^^^^^^the third paramter are the local var's. You can update them within the current process, but they are data local to the process.
Updating the environment via
$ENV{FOO} = 'bar'.
has the same effect as:
export FOO='bar';
at the shell: it sets the variable for the duration of a single execution.
If you want to modify the contents of ORACLE_SID or ORACLE_ASK and then have oracle run with them you need to set the environment up first then run the job:
export ORACLE_SID = 'foobar'; sqlplus scot/tiger;
or
$ENV{ORACLE_SID} = 'foobar';
system( 'sqlplus scot/tiger' );will do the same thing. You could also fork/exec the sqlplus instead of letting system do it for you.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 888 359 3508
