Sponsored Content
Full Discussion: What am I doing wrong
Top Forums UNIX for Advanced & Expert Users What am I doing wrong Post 77166 by guptan on Tuesday 5th of July 2005 10:11:03 AM
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
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
ERROR::PASS1(7stap)													       ERROR::PASS1(7stap)

NAME
error::pass1 - systemtap pass-1 errors DESCRIPTION
Errors that occur during pass 1 (parsing) usually mean a basic syntax error of some sort occurred in the systemtap script. There are sev- eral classes of problems possible: plain syntax error The systemtap script parser detects a large variety of errors, such as missing operands, bad punctuation. It tries to list what kinds of tokens it was expecting to see, and will show the region of the source code with the problem. Please review the stap(1) man page and/or the tutorial, to correct the script's syntax. grammar ambiguities There is at least one known ambiguity in the systemtap grammar. It relates to the optionality of ; (semicolon) separators between statements, and the ++ and -- increment/decrement operators. If the parser indicates an error, consider adding some explicit ; sep- arators between nearby statements and try again. missing command line arguments A systemtap script that uses the $N and @N constructs for substituting in command-line options may fail if not enough options were given on the stap command line. compatibility changes Some versions of systemtap have changed the language incompatibly, for example by adding the try/catch keywords for exception han- dling. In such cases, rerun systemtap with the --compatibility=VERSION option, substituting the last systemtap version where your script was known to work. You may also check the release-history NEWS file for compatibility changes. GATHERING MORE INFORMATION
Increasing the verbosity of pass-1 with an option such as --vp 1 can help pinpoint the problem. SEE ALSO
stap(1), error::reporting(7stap) ERROR::PASS1(7stap)
All times are GMT -4. The time now is 05:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy