topic Re: problem running sql script in unix 11:00 in Operating System - HP-UX

problem running sql script in unix 11:00

Cathy Arora — Fri, 07 Nov 2003 10:47:03 GMT

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.

Re: problem running sql script in unix 11:00

Umapathy S — Fri, 07 Nov 2003 10:52:48 GMT

I am not familiar with oracle or sqlplus.

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

Umapathy

Re: problem running sql script in unix 11:00

Mark Greene_1 — Fri, 07 Nov 2003 10:57:15 GMT

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

Re: problem running sql script in unix 11:00

Michael Schulte zur Sur — Fri, 07 Nov 2003 10:57:18 GMT

Hi,

check permission of the script and the path to it.

Michael