problem executing sql script

[Cathy Arora]

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.

[Graham Cameron_1]

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

[David Andrews_1]

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.