topic Re: problem executing sql script in Operating System - Linux

problem executing sql script

Cathy Arora — Fri, 07 Nov 2003 10:16:23 GMT

I am having problrm running script in sqlplus on unix 11:00 box
as an example
I have simple script saved in my home/scripts called whoami
ams i tried running at sqlplus probpt after logging in and got following error
I change the permission on the script as well.
SQL> @whoami
SP2-0310: unable to open file "whoami.sql"

SQL>
Help is appreciated.

Re: problem executing sql script

Graham Cameron_1 — Fri, 07 Nov 2003 10:26:37 GMT

Cathi

SQLplus will look for scripts in your current directory, then in the directory pointed to by $SQLPATH, if set.
Extension should be .sql

It evidently can't find whoami.sql in either of these.

Did you cd into home/scripts before firing up sqlplus ?

-- Graham

Re: problem executing sql script

David Andrews_1 — Fri, 07 Nov 2003 11:00:31 GMT

Cathy,

As Graham has correctly stated sqlplus looks for sql scripts with an extension of .sql

It automatically assumes that there is an extension of .sql on the file, if another extension has not been stated.

If your script is in /home/scripts
and is called whoami

First rename the script whoami to whoami.sql

Then, from a SQL> prompt type either

@/home/scripts/whoami

or

@/home/scripts/whoami.sql

They equate to the same thing.