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.