|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Script to simulate hanging process | brendan76 | Linux | 4 | 09-16-2008 07:25 AM |
| Help with EXPECT script hanging | markus2008 | UNIX for Dummies Questions & Answers | 0 | 03-11-2008 03:44 PM |
| Hanging port? | NycUnxer | UNIX for Dummies Questions & Answers | 1 | 01-09-2008 02:21 PM |
| script hanging - remsh | vivsiv | Shell Programming and Scripting | 2 | 07-09-2006 04:41 PM |
| hanging sql script | inquirer | UNIX for Dummies Questions & Answers | 4 | 12-26-2001 10:11 PM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
11-18-2008
|
||||
|
||||
|
Script is hanging
Hello,
I have the following shell script and when i execute, it keeps hanging and nothing happens Please let me know. Requirement is to read data from file and pass it to the sql and create files as shown. code Code:
/********
#!/bin/sh
while read user.dat
do
echo "user = $1 email = $2"
done
sqlplus -S /NOLOG << EOF
connect username/pwd@schema
select user_name,count(*) from apps.fnd_user
where 1=1 and user_name ('$1') and email_address ('$2')
group by user_name;
EOF
if $? -ne 0
then
% cat > user_exist
else
% cat > user_notexist
fi
exit 0
*******/
rsreenivasa null Last edited by DukeNuke2; 11-18-2008 at 01:57 PM.. Reason: added code tags for better reading |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
