Re: Passing integer values from shell script to a .sql file

From: anju <anjani.unix.help_at_gmail.com>
Date: 6 Jun 2006 07:17:59 -0700
Message-ID: <1149603479.857457.233930@i39g2000cwa.googlegroups.com>

Maxim Demenko wrote:
> anju schrieb:
> > Hi All,
> >
> > i'm facing the below problem in passing integer values.
> >
> >
> > -------------------------------------------------------
> > $ ./ex5.sh
> > insert into emp values ($1,'$2',$3,'$4')
> > *
> > ERROR at line 1:
> > ORA-00911: invalid character
> > -------------------------------------------------
> >
> > Script
> >
> > ==========================
> > $cat ex5.sh
> > #!/usr/bin/bash
> >
> > # this is a sample file to insert data into a table
> >
> > USERNAME="system"
> > PASSWD="passwd"
> > SID="orcl"
> > declare -i val1=102
> > val2="tom"
> > declare -i val3=40000
> > val4="boston"
> >
> > # database connection and updation.
> >
> > sqlplus -s $USERNAME/$PASSWD <<EOF
> > @"/home/abc/second.sql" $val1 $val2 $val3 $val4
> > EOF
> > ========================================
> >
> > SQL file
> >
> > ++++++++++++++++++++++++
> > insert into emp values ($1,'$2',$3,'$4')
> > /
> > ++++++++++++++++++++++++
> >
> >
> >
> > How can i pass integer values to the sql script.
> >
> >
> > Thanks in advance,
> > an
> >

>

> cd /home/abc
> sed 's/\$/\&/g' second.sql > second_new.sql
> mv second_new.sql second.sql

>

> Best regards

>
> Maxim

Thanks maxim,

actually i should use my .sql file insert stmt in the following way

insert into emp values (&1,'&2',&3,'&4')

Thanks once again,
Have a great day,
an Received on Tue Jun 06 2006 - 09:17:59 CDT