On HP unix , logging as a oracle user we are unable to run a sql script.
giving below command.
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 ?
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