I am inserting record in oracle database using shell script. When the sql part is directly written in the shell script the record is getting inserted. But when the same piece of code is added into a function, I am getting an error while execution "line 45: syntax error: unexpected end of file".
The file is containing only 44 lines of code.
The function which is called from a main function in which the code for insert is written is as follows. When the entire SQL section is removed from the function the program executes properly.
Any suggestions/inputs would be great help.
TIA
Code:
add ()
{
sqlplus -s "custom/custom"<<EOF
insert into name_list values ('$f_name','$l_name');
exit
EOF
if [ $? -ne 0 ]; then
echo "Error in insertion"
add;
else
echo -e "\nRecord added successfully... Do you wish to add more(y/n) \c"
read choice
if [ $choice == "y" ]; then
add ;
else
clear
main ;
fi
fi
}
Last edited by methyl; 03-28-2012 at 11:47 AM..
Reason: please use code tags
Hi friends,
I am using Sun Solaris 5.9. I want to take backup of 3 folders which are 50 GB in size totally using tar command on tapes. I am having DAT 72 tape. After initiating tar command (tar -cvf /dev/rmt/0n /tmp/dir1/ /tmp/dir2/ /tmp/dir3/), tarring is stopped after 10 hrs (approx) and i am... (7 Replies)
I am taring to disk and get this message:
tar: write error: unexpected EOF
This message is normally associated with tape devices, not disk.
Here is the syntax:
tar -cf <tarfilename> /dir
Have you seen this message on disk tars? (4 Replies)
Hi,
I am newbie and am just trying to connect to oracle from shell script ,,,but I am getting the following error
./prog.sh: line 20: syntax error: unexpected end of file
The scripts is :
#!/bin/bash
O=$IFS; IFS=",";
while read a b c d
do
echo $c
... (6 Replies)
I need archive data from some tar files. I use the command "tar xvf
filename". For about half of the files I get the error message
"tar:read error: unexpected EOF".
The number of bytes extracted comes very close to the size of the
tar file.
An example:
972434779 Jan 10 01:01... (4 Replies)
I have a script which throws an error: "here document `EOF' unclosed"
The script is:
...
main()
{
RETVAL=`sqlplus -s $ConnectDetails << EOF
SET SERVEROUTPUT ON
DECLARE
errnum NUMBER;
errmsg VARCHAR2(1000);
BEGIN
My_Procedure( errbuf => errmsg, errcode... (2 Replies)
I am trying to check the return status of a command thats encapsulated
in an <<EOF
#!/bin/ksh
set -x
xxx()
{
set -x
ls -lt /tmp/jdlkewjdlkewjdlkewjdlewjdlew<<EOT
ret=$?
EOT
echo "ret=$ret"
} >>$LOG 2>&1
LOG=/tmp/t2.out
rm -rf $LOG
echo "Starting process `date... (2 Replies)
tar: write error: unexpected EOF
I usually encounter this when I'm doing backup to Dat72 tape. Here's the command
gzip all files in a directory then tar cvfp /dev/rmt/0n files. Not all files are copied. Any things I should look at? Directory size?
---------- Post updated at 05:20 PM... (1 Reply)
Below is a test script I'm writing in the process of learning to write script. When I try to run it I get an unexpected end of file error on line 56. Thoughts?
SCRIPT:
#!/bin/bash
# system_page - A script to produce a system information HTML file
##### Constants
TITLE="My System... (1 Reply)
Hi,
can someone kindly look into my copy script and figure out why am i getting a "unexpected EOF while looking for matching `"' error message
#!/bin/ksh -x
cd /home/goldenga/test/flag37
if ; then
rm copied.ok
cd /home/goldenga/test
Upper=`ls -t|grep 'qw*'|cut -d "w" -f 2|head... (4 Replies)
Discussion started by: NDalal007
4 Replies
LEARN ABOUT V7
dh_installdeb
DH_INSTALLDEB(1) Debhelper DH_INSTALLDEB(1)NAME
dh_installdeb - install files into the DEBIAN directory
SYNOPSIS
dh_installdeb [debhelperoptions]
DESCRIPTION
dh_installdeb is a debhelper program that is responsible for installing files into the DEBIAN directories in package build directories with
the correct permissions.
FILES
package.postinst
package.preinst
package.postrm
package.prerm
These maintainer scripts are installed into the DEBIAN directory.
Inside the scripts, the token #DEBHELPER# is replaced with shell script snippets generated by other debhelper commands.
package.triggers
package.shlibs
These control files are installed into the DEBIAN directory.
Note that package.shlibs is only installed in compat level 9 and earlier. In compat 10, please use dh_makeshlibs(1).
package.conffiles
This control file will be installed into the DEBIAN directory.
In v3 compatibility mode and higher, all files in the etc/ directory in a package will automatically be flagged as conffiles by this
program, so there is no need to list them manually here.
package.maintscript
Lines in this file correspond to dpkg-maintscript-helper(1) commands and parameters. However, the "maint-script-parameters" should not
be included as debhelper will add those automatically.
Example:
# Correct
rm_conffile /etc/obsolete.conf 0.2~ foo
# INCORRECT
rm_conffile /etc/obsolete.conf 0.2~ foo -- "$@"
In compat 10 or later, any shell metacharacters will be escaped, so arbitrary shell code cannot be inserted here. For example, a line
such as "mv_conffile /etc/oldconffile /etc/newconffile" will insert maintainer script snippets into all maintainer scripts sufficient
to move that conffile.
It was also the intention to escape shell metacharacters in previous compat levels. However, it did not work properly and as such it
was possible to embed arbitrary shell code in earlier compat levels.
The dh_installdeb tool will do some basic validation of some of the commands listed in this file to catch common mistakes. The
validation is enabled as a warning since compat 10 and as a hard error in compat 12.
SEE ALSO debhelper(7)
This program is a part of debhelper.
AUTHOR
Joey Hess <joeyh@debian.org>
11.1.6ubuntu2 2018-05-10 DH_INSTALLDEB(1)
03-28-2012
