Visit Our UNIX and Linux User Community


./1.sh: Syntax error at line 1 : `<<' is not matched.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting ./1.sh: Syntax error at line 1 : `<<' is not matched.
# 1  
Old 03-24-2015
./1.sh: Syntax error at line 1 : `<<' is not matched.

Code:
function user {
         sqlplus primeit@$ORACLE_SID/primeit <<EOF
       select user_name from test;
        EOF
        }

function gen {
        genpwdfile dec -in $1 -out $2
        echo $1
        echo $2
        }

function reset {
        sqlplus primeit@$ORACLE_SID/primeit <<EOF
        select user_name from user;
        EOF
        }

---------- Post updated at 05:28 AM ---------- Previous update was at 05:27 AM ----------

This is error i am getting when m trying to use functions such "USER" but when i am trying to access same directly on the command line it goes to sql without an issue.

Last edited by ripudaman.singh; 03-24-2015 at 07:35 AM..
# 2  
Old 03-24-2015
The ending label of here document (EOF in your case) must be at the beginning of the line unless you have used -EOF which allows the use of tabs (not spaces) at the beginning.

Code:
function reset {
        sqlplus primeit@$ORACLE_SID/primeit <<EOF
        select user_name from user;
EOF
        }

OR
Code:
function reset {
        sqlplus primeit@$ORACLE_SID/primeit <<-EOF
        select user_name from user;
         EOF  ## must be tabs not spaces
        }

# 3  
Old 03-24-2015
Code:
function user{
        sqlplus primeit@$ORACLE_SID/primeit <<EOF
      select user from test;
        EOF
        }

function gen{
        genpwdfile dec -in $1 -out $2
        echo $1
        echo $2
        }

function reset{
        sqlplus primeit@$ORACLE_SID/primeit <<EOF
       select user_name from user;
        EOF
        }

its giving an error now 1.sh: Syntax error at line 2 : `sqlplus' is not expected.
# 4  
Old 03-24-2015
Have you checked my post carefully?
# 5  
Old 03-24-2015
yes i have user tab ..
# 6  
Old 03-24-2015
I am not seeing the <<-EOF in your modified code.
# 7  
Old 03-24-2015
thanks a lot its got sorted but further i am getting error
Code:
SQL*Plus: Release 11.2.0.2.0 Production on Tue Mar 24 15:12:42 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ERROR:
ORA-12545: Connect failed because target host or object does not exist


Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

and when i am running from the same user as primeit/ptimeit its working there

Last edited by rbatte1; 03-24-2015 at 09:41 AM.. Reason: Added CODE tags

Previous Thread | Next Thread
Test Your Knowledge in Computers #160
Difficulty: Easy
The Internet Autonomous Network Authority (IANA) is responsible for maintaining the official assignments of Internet port numbers.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

0403-057 Syntax error at line 399 : `"' is not matched

Hi Everyone, I am getting strange behavior, same script runs fine without any error in one AIX machine, whereas on another it is throwing this error "0403-057 Syntax error at line 399 : `"' is not matched", I also ran the script in debug mode. This is the output, still doesn't say anything.... (2 Replies)
Discussion started by: sid1987
2 Replies

2. Shell Programming and Scripting

0403-057 Syntax error at line 169 : `"' is not matched.

Hi, I am getting this error in my attached shell script, kindly help as soon as possible: Thanks, Andre (2 Replies)
Discussion started by: damoon
2 Replies

3. Shell Programming and Scripting

[Solved] 0403-057 Syntax error `<' is not matched

curr_time=`date +%Y%m%d%H%M` curr_date=`date +%Y%m%d` zero=0 script_path="/home/wccuser1/wcc/Scripts/bulk_file_ftp" file_dir="/home/wccuser1/wcc/Bulk_Files" todays_file_count=`ls -ltr | grep $curr_date | awk '{print $9}' | wc -l` todays_file=`ls -ltr | grep $curr_date | awk '{print $9}'` if... (5 Replies)
Discussion started by: gagandeep
5 Replies

4. Shell Programming and Scripting

Receiving error: ./ang.ksh[35]: 0403-057 Syntax error at line 116 : `done' is not expected.

Hi All I am quite new to Unix. Following is a shell script that i have written and getting the subject mentioned error. #!/bin/ksh #------------------------------------------------------------------------- # File: ang_stdnld.ksh # # Desc: UNIX shell script to extract Store information.... (3 Replies)
Discussion started by: amitsinha
3 Replies

5. Shell Programming and Scripting

Makefile: syntax error at line 1

I am able to 'Make' some of projects's modules using GNU's make except one where it throws me the following error gmake -f Makefile /bin/sh: syntax error at line 1: `if' unexpected gmake: *** Error 2 I am sure it has nothing to do with the Makefile as there is no 'if' in the first... (1 Reply)
Discussion started by: sudsa
1 Replies

6. UNIX for Advanced & Expert Users

sh: syntax error at line 8 : `<<' is not matched.

Hi, I am trying to execute the above attached script. and i am getting the error as syntax error at line 8: `<<' is not matched. While i am trying to run that particular line (cat <<EOF > /tmp/query.sql) independently in the prompt it is running successfully without any error. I am running... (2 Replies)
Discussion started by: satyaatcgi
2 Replies

7. Shell Programming and Scripting

ERROR: ./launch_full_backup.sh[18]: Syntax error at line 28 : `else' is not expected.

Help please! :confused: I have the following error with the following file and the emails are not arriving to the email, any idea please? ERROR: ./launch_full_backup.sh: Syntax error at line 28 : `else' is not expected. FECHA=`date +%d%m%y%H%M`... (2 Replies)
Discussion started by: villenan
2 Replies

8. Shell Programming and Scripting

Syntax error at line 11 : `for' is not matched.

hi , while running this script i am getting below error: Syntax error at line 11 : `for' is not matched. here is program: #! /bin/ksh sqlplus -s << !+! user/password update GR_SUB_SCRIPT_PC set act_del_ind='0'; commit; exit; !+! cd /home/salunke/pvcsfiles/source_files for i in... (5 Replies)
Discussion started by: digambar
5 Replies

9. Shell Programming and Scripting

get_source[34]: 0403-057 Syntax error at line 66 : `"' is not matched.

Hi, I am getting this error in my shell script, kindly help as soon as possible: ################################################################### # Main body of program ################################################################### . /saptech/scripts/common/declare # Defines... (1 Reply)
Discussion started by: vishal_ranjan
1 Replies

10. Programming

sh: syntax error at line 1: `>' unexpected

I compiled C program under SUN OS sparcv9 ...I had a problem related to SIGBUS which has been resolved by adding an option to the CC compiler which is memory alignement option ..-memalign=1i as I remmber ...after running the program I got the below error please let me KNow more details what should... (2 Replies)
Discussion started by: atiato
2 Replies

Featured Tech Videos