Escape character for period '.' with SQLPLUS and shell script ?

From: zw <MPC8250_at_gmail.com>
Date: Sat, 2 Feb 2008 23:02:08 -0800 (PST)
Message-ID: <c9171b53-1e99-4ff8-9c24-861eaf26d18d@v46g2000hsv.googlegroups.com>

Hi

I have the following:

The 9th variable is TEST

shell script A.sh

---

B.sh $1 $2 $3 $4 $5 $6 $7 $8 $9

shell script B.sh

---

C.sh $tmp $locate $5 $7 $3 $4 $9 &

shell script C.sh

---

sqlplus -s $5/$6@$7 @no_session.sql $3 >> $fc1

no_session.sql

---

select count(*) Q2_STATUSLOG from &1.Q2_STATUSLOG;

When I tail file fc1, I saw this:

old 1: select count(*) Q2_STATUSLOG from &1.Q2_STATUSLOG new 1: select count(*) Q2_STATUSLOG from TESTQ2_STATUSLOG select count(*) Q2_STATUSLOG from TESTQ2_STATUSLOG

                                    *

ERROR at line 1:
ORA-00942: table or view does not exist

I was expecting SQLPLUS to correctly find the table TEST.Q2_STATUSLOG when replacing &1 with TEST but somehow the '.' is missing. Is there a workaround to make sure the '.' is there ? Is there a way to make an escape for '.'. I cannot change TEST to TEST. to pass as argument, only TEST

Thanks Received on Sun Feb 03 2008 - 01:02:08 CST