running a script

[b_madhavi]

hi,

On HP unix , logging as a oracle user we are unable to run a sql script.
giving below command.
svrmgrl>@/avl1/oracle/file_name.sql
once we press Return it is comming to next line.If we type ";" and return
it is giving sql command not properly ended etc.

we tried with some simple sql script , that is also not working.

For time being we typed the contents of the sql file.

can any one suggest what settings has to be done at OS level and Oracle level.
where does '@' executable reside.
Do I need to set any Path ?

can any one help us in this matter.

Your earliest help is kindly appreciated.

thanks and regards,

madhavi

[SANJAY_G]

Try running the scripts from sqlplus instrad of svrmgrl.

Sanjay

[oradbadmin]

You can set the env variable SQLPATH pointing to all the directories containing your scripts.
In this way you can call your scripts everytime simply using an @ without specifing the script destination path.
However if your script is in the current directory and it is not spiecified in the SQLPATH env variable you can call it using a double @ (example @@myscript)
Remember that this variable is only read by SQLPLUS and not by SVRMGR
Bye.

[Tatyana]

You must write only the name of script without .sql .

[pwoneill]

Adding the .sql shouldn't prevent it from executing, you can do it either way.

Can you post your script? If it's giving a sql command not properly ended odds are it's executing your script but the script contains an error.

[arshiah]

I agree.
Sometimes by add a / at the very end (last line) helps too. Try it :-)

[Kishore]

Running from svrmgrl also should work provided you are running on the tables available from that level.

So in your case, it may be some adding / or ; in your script. Just post it and some of us will help u.