My sql script is as follows iam callling the sql query from my email creation script sqlplus -s SB/s...@spcl <<EOF select employee_name,last_name from employee_master where employee_id = $erpno ; EXIT; EOF; exit
now i want to pass the value of employee_name & last_name to 2 different value and pass the value to my script once them control is passed from sql script to my shell script --- On Thu, 21/5/09, Nadeem M. Khan <[email protected]> wrote: From: Nadeem M. Khan <[email protected]> Subject: Re: [LinuxVadaPav] How to redirect oracle sql query output to a text file To: [email protected] Date: Thursday, 21 May, 2009, 9:19 PM On Thu, May 21, 2009 at 4:56 PM, ashok abraham <ashok...@yahoo. com> wrote: > > > thanx for the overwhelming support > > it is working now with spooler setiings > > now i want to go one more step in advance > > i have a email id creation script for creating emailid for our org > now iam manully prompting & keying the first name & lastname via my script > now i want to get firstname & lastname from my erp oracle databse with > the erpno as input and store the firstname and lastname from the database > to 2 different variable > and create my email id with the output from the query of output Send us the output of your sql query and we can help. Regards, NMK. Own a website.Get an unlimited package.Pay next to nothing.*Go to http://in.business.yahoo.com/ [Non-text portions of this message have been removed]
