Problem while storing sql query value in a variable

krishna_gnv · #1 (**permalink**) 02-28-2008

Hi,

When i execute the below statement , the value is not getting stored in the variable.

AnneeExercice=`sqlplus $LOGSQL/$PASSWORDSQL << FIN >> $GEMOLOG/gemo_reprev_reel_data_ventil_$filiale.trc
SELECT bi09exercice
FROM bi09_scenario
WHERE bi09idfiliale=UPPER('de')
AND bi09flagcourant='O'
AND bi09cycle='R' ;
FIN`

I got struck at this point. Can you please suggest me whats wrong in the statement.

grial · #2 (**permalink**) 02-28-2008

Well, you are redirecting standard output to $GEMOLOG/gemo_reprev_reel_data_ventil_$filiale.trc
Either remove this redirection or change the ">>" into "2>"...
At least, assuming all the other stuff is OK...

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Storing a variable?	hoover90	Shell Programming and Scripting	4	01-26-2008 09:39 PM
Problem storing SSH result in a variable	prash184u	Shell Programming and Scripting	1	01-17-2008 04:41 PM
storing database query in a variable	debu	Shell Programming and Scripting	3	11-25-2007 07:59 PM
Storing the output into a variable	ravi raj kumar	UNIX for Dummies Questions & Answers	7	12-11-2006 09:14 AM
storing output of awk in variable	mab_arif16	Shell Programming and Scripting	3	05-07-2006 06:15 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 Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by