problem running scrip in unix at sqlplus

[Cathy Arora]

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

[Anna Fong]

@/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.

[Yogeeraj_1]

hi,

also make sure that the script name is whoami.sql

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

regards
Yogeeraj

[Arturo Galbiati]

@/home/kchinsky/scripts/whoami

and I suggest you to change

cd ....

with

!cd ....

to avoid any error.

Art

[T G Manikandan]

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

#mv whoami to whoami.sql

$sqlplus @database
sql@whoami


REvert

[Jean-Luc Oudart]

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

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

Rgds,
JL