problem running sql script in unix 11:00

[Cathy Arora]

HI all ; i know it is a begining Q but any help is appreciated
I have login1.sql in my home/scripts in ho unix box
when I run this script on under sqlplus on sql promt i get this error
SQL> @login1.sql
SP2-0310: unable to open file "login1.sql"
can some on help.

[Umapathy S]

I am not familiar with oracle or sqlplus.

Whether this will work?
SQL> @./login1.sql

Umapathy

[Mark Greene_1]

Run this to determin where the login1.sql file is:

find / -name 'login1.sql' -print

and then check the PATH variable in your .profile (or in the script, if there is one) to ensure that the full directory reference to the file is there.

mark

[Michael Schulte zur Sur]

Hi,

check permission of the script and the path to it.

Michael