running SQL script in UNIX command script

From: Dave <phldmgold_at_yahoo.com>
Date: 4 Dec 2003 09:51:51 -0800
Message-ID: <b45e1530.0312040951.2b4fa2e7@posting.google.com>

Oracle 8.1.7.3:

I have the following in a UNIX shell script:

#!/bin/ksh
sqlplus /NOLOG <<!
connect johndoe/password;
select count(token_text) from dr$item_ctxdesc$i;

When I run it, I get this output:

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 4 12:50:20 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> Connected.
SQL> select count(token_text) from dr

                              *

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

SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production

So, it's running, connecting as my user, and then trying to run the select statement and failing at the 'from' command.

When I run this statement at the SQL prompt, or in a SQL script(called with @script.sql) it works.

What am I missing? Received on Thu Dec 04 2003 - 11:51:51 CST