In a shell script, I am storing some values into variables. In between the code I am calling an PL/SQL precedure by connecting to ORACLE which generates a file. All this happens fine.

The problem is, the values are not getting stored in variables after this PL/SQL code while perfectly before the code. The PL/SQL sets the following setting for PL/SQL procedure execution.


export ORACLE_SID=TATTQ
export ORACLE_BASE=/oracle2/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export PATH=$ORACLE_HOME/bin:/usr/ccs/bin:/usr/bin:/etc:/usr/bin/X11/usr/local/bin:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/lib
export SHLIB_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/lib:/opt/omni/lib
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_NCHAR=AL16UTF16

Can anyone tell me what's the problem with? And why values are not stored in variables?

Thanks in advance.

This could be your solution. variable assignment in new shell

vino