Command-Line Utility Program for Oracle
1
vote
1answer
128 views
How do I execute an Oracle SQL script without sqlplus hanging on me?
For an automated task I would very much like to run some SQL scripts and make sure that sqlplus does not hang under any circumstancees, i.e.:
If the script contains any named substitution variable ...
1
vote
1answer
101 views
Invalid File Name on login to SQLPLUS
The moment I log into SQLPLUS I get an SP2-0556 error. I recently moved OS but am connecting to the same database so I am not sure if it's because I'm using my old TNSNames or what. I can connect and ...
2
votes
0answers
1k views
Encoding problems with sqlplus, Linux
I use sqlplus and all non-Latin characters appear as '?' when I run select queries. When I run insert or update queries with non-Latin characters I get question marks on a web page.
select * from ...
2
votes
0answers
779 views
SQL*Plus, @, and relative paths
Somehow, it seems that SQL*Plus (at least on Windows) is unable to locate a script with a relative path when called with @@ and when the path starts with a single or double dot.
For example, under ...
