What am I doing wrong


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users What am I doing wrong
# 1  
Old 07-05-2005
What am I doing wrong

When I execute following shell script I am getting the following error

syntax error at line 50 : `<<' unmatched

What am I doing wrong Smilie

Script begins here
----------------

MPAN_FILE=$1

exec 3<$MPAN_FILE

while read -u3 -r Outcode Incode Depot
do
echo $Outcode
echo $Incode
echo $Depo

{
sqlplus -S abc/xyz <<EOF
set heading off feedback off serveroutput on

DECLARE
DEPO number;
BEGIN
-- Attempt to find the depo
SELECT DEPOT_CODE
INTO DEPO
FROM DEPOT
WHERE UPPER(DEPOT_LKVAL) = UPPER('${Depot}');

-- Found it, print the depo
DBMS_OUTPUT.PUT_LINE (Depo);

EXCEPTION
-- No depo
WHEN NO_DATA_FOUND THEN
SELECT -1
INTO Depo
FROM dual;
DBMS_OUTPUT.PUT_LINE (Depo);
WHEN OTHERS THEN
SELECT -2
INTO Depo
FROM dual;
DBMS_OUTPUT.PUT_LINE (Depo);
END;
/
EOF
} | read Depo

echo $Depo
if [ ${Depo} -ge 0 ]
then
echo 'Success'

{
sqlplus -S abc/xyz <<EOF
set heading off feedback off serveroutput on

DECLARE
Err number;
BEGIN
-- Attempt to Insert the data into depot_postal_area
INSERT INTO DEPOT_POSTAL_AREA
(SUPPLIER_CODE,DEPOT_CODE,POST_OUTCODE,POST_INCODE)
VALUES
(12,${Depo},'${Outcode}','${Incode}');

INSERT INTO DEPOT_POSTAL_AREA
(SUPPLIER_CODE,DEPOT_CODE,POST_OUTCODE,POST_INCODE)
VALUES
(13,${Depo},'${Outcode}','${Incode}');

Err := 0;
DBMS_OUTPUT.PUT_LINE (Err);
EXCEPTION
-- No depo
WHEN OTHERS THEN
SELECT -1
INTO Err
FROM dual;
DBMS_OUTPUT.PUT_LINE (Err);
END;
/
EOF
} | read Error

echo $Error

else
echo 'Failed'
fi
done
# 2  
Old 07-05-2005
run the script with the 'set -x' set and debug the output.
# 3  
Old 07-05-2005
I am getting the syntax error not the execution error.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Why result is wrong here ? whether break statement is wrong ?

Hi ! all I am just trying to check range in my datafile pls tell me why its resulting wrong admin@IEEE:~/Desktop$ cat test.txt 0 28.4 5 28.4 10 28.4 15 28.5 20 28.5 25 28.6 30 28.6 35 28.7 40 28.7 45 28.7 50 28.8 55 28.8 60 28.8 65 28.1... (2 Replies)
Discussion started by: Akshay Hegde
2 Replies

2. UNIX for Advanced & Expert Users

What am I doing wrong here?

I am working on a simple login ID check shell script that should prompt for a user ID then check to see if this user is logged on. Trying to get the hang of this stuff so I am thinking of my own little projects. #! /bin/sh echo "please enter a user name" read user if user=$user then... (3 Replies)
Discussion started by: jsk319342
3 Replies

3. Shell Programming and Scripting

Is there anything wrong?

For one of my script, I want one extra parameter needs to be added to one of the Usage option. Below its given #Check Input parameters are valid if ; then function usage() { echo echo "*******************************************" echo " !!! USAGE... (2 Replies)
Discussion started by: raghunsi
2 Replies

4. UNIX for Dummies Questions & Answers

What is wrong in here ???

]#PATH=/usr/bin:/etc:/bin:/boot/grub:/boot/grup/bin: /boot/solaris/bin:/sbin:/usr/openwin/bin:/usr/5bin://usr/X11/bin:/usr/apache/bin:/usr/apache2/bin:/usr/appserver/bin:... (9 Replies)
Discussion started by: microbot
9 Replies

5. Shell Programming and Scripting

what I m doing wrong?

when user select option 2 nothing happen.for testing purpose I put echo command but is not executing . basically when user prompt for option 2,I want to get list of database name from user separeted by space (TEST DEVL) and put into the file seprated by new line TEST DEVL after that stay on... (1 Reply)
Discussion started by: okreporthai
1 Replies

6. UNIX for Dummies Questions & Answers

what is wrong with this tr -d?

here is my command in bash shell on Mac OS X tiger: history | tr -d emacs here is what I get: hitory | grp "" | tr -d "" hitory | grp "" | tr -d """" hitory | grp "" | tr -d '' hitory | grp "" | tr -d '' hitory | grp "" | tr -d '' hitory | grp "" | tr -d... (3 Replies)
Discussion started by: cleansing_flame
3 Replies

7. UNIX for Dummies Questions & Answers

What am I doing wrong?

I really just mess around in UNIX, for the most part, when I want to get something done. I can usually piece things together by searching for brief how-to's on Google, but the syntax errors in my following .sh file are really confusing me. I've got lots of programming experience in other places, so... (7 Replies)
Discussion started by: demonpants
7 Replies

8. UNIX for Dummies Questions & Answers

what is wrong here

Hello, I have a simple script such as ----------------------------- #! /bin/sh YEAR=`date -u +%Y`; MONTH=`date -u +%m`; DAY=`date -u +%d`; DATE=$MONTH$DAY$YEAR LOGFILES=auditTrail-$DATE LOGMATCH=$LOGFILES\* ARGUM='' # find all files and write them to a file find . -name... (7 Replies)
Discussion started by: arushunter
7 Replies

9. Shell Programming and Scripting

Anything wrong with this

Does anyone see anything wrong with this. #getInfraFiles() #{ # cd Infra/$DAY # rm * # /usr/bin/ftp -i -n $LINE << cmd # user "$USER" "$PASSWD" # cd $INFRAPATH # binary # mget * # bye #} besides that its commented out (4 Replies)
Discussion started by: rcunn87
4 Replies

10. UNIX for Dummies Questions & Answers

Please tell me what do I do wrong here!

#!/usr/bin/csh # DAY=`date +%y%m%d` H=`date +%H` M=`date +%M` mailx -s "$H-Myfile" email@email.com</home/mydir/myfile Thanks! (4 Replies)
Discussion started by: bobo
4 Replies
Login or Register to Ask a Question