topic Re: problem running scrip in unix at sqlplus in Operating System - HP-UX

problem running scrip in unix at sqlplus

Cathy Arora — Fri, 07 Nov 2003 12:02:09 GMT

Thanks all,
I already had changed the permissions
However i added the location of my script with in the script and still I get the same error
and script looks like this (just for test)
name of the script whoami

cd /home/kchinsky/scripts
show user
select * from global_name
exit

I logon to sqlplus
user/pasword
@whoami
and I get
SP2-0310: unable to open file "whoami.sql"
any help is appreciated

Re: problem running scrip in unix at sqlplus

Anna Fong — Fri, 07 Nov 2003 12:52:50 GMT

@/home/kchinsky/scripts/whoami

To not have to specify whole path, put your script path in your PATH env.

Also, mixing UNIX commands in your SQL will generate errors.

Re: problem running scrip in unix at sqlplus

Yogeeraj_1 — Fri, 07 Nov 2003 13:12:11 GMT

hi,

also make sure that the script name is whoami.sql

can you post the output of:
SQL> ! ls -al w*.sql

regards
Yogeeraj

Re: problem running scrip in unix at sqlplus

Arturo Galbiati — Mon, 10 Nov 2003 04:15:40 GMT

@/home/kchinsky/scripts/whoami

and I suggest you to change

cd ....

with

!cd ....

to avoid any error.

Art

Re: problem running scrip in unix at sqlplus

T G Manikandan — Mon, 10 Nov 2003 04:26:26 GMT

anyfile you run with sqlplus I prefer it to rename it to <script>.sql

#mv whoami to whoami.sql

$sqlplus @database
sql@whoami

REvert

Re: problem running scrip in unix at sqlplus

Jean-Luc Oudart — Mon, 10 Nov 2003 08:37:48 GMT

The original post is here
(with the solution but ... no rabbit)

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=246948

Rgds,
JL