When can a script deny to store any value in a variable

mitte_dino · #1 (**permalink**) 10-04-2005

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.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Need to get pid of a process and have to store the pid in a variable	samudha	UNIX for Dummies Questions & Answers	7	08-05-2008 04:24 AM
How to store query multiple result in shell script variable(Array)	div_Neev	Shell Programming and Scripting	4	11-06-2007 08:10 PM
How to Store command O/P to a variable...	smartbuddy	UNIX for Dummies Questions & Answers	7	08-24-2007 08:49 AM
To store the output in a variable	Sudhakar333	Shell Programming and Scripting	2	07-10-2007 09:45 AM
store awk results in a variable	forever_49ers	Shell Programming and Scripting	1	09-19-2006 11:51 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by