<div>
Nevermind.....<br />
<br />
The *.sql file in question was actually being written by my script, and I never did a file.close(). &nbsp;Therefore windows apparently refused access to the file, with no messages or exception. &nbsp;Screwed once again by Windows!<br />
Question - do I get the 500 points for answering myself?
</div>


Nevermind.....

The *.sql file in question was actually being written by my script, and I never did a file.close().  Therefore windows apparently refused access to the file, with no messages or exception.  Screwed once again by Windows!
Question - do I get the 500 points for answering myself?

<div>
Site help for &quot;I answered my question myself. What do I do?&quot;:<br />
<br />
<a href="https://www.experts-exchange.com/help.jsp#hi70" rel="ugc">https://www.experts-exchange.com/help.jsp#hi70</a>
</div>


Site help for "I answered my question myself. What do I do?":

https://www.experts-exchange.com/help.jsp#hi70 [https://www.experts-exchange.com/help.jsp#hi70]

<div>
<div class="content wysiwyg-content">
I need to call Oracle Sql*Plus from a python script. &nbsp;If I put the call to sql*plus like this:<br />
os.system('sqlplus /NOLOG @my_script')<br />
Then the @my_script will never get passed. Even if I put the line inside callit.bat and do:<br />
os.system('callit.bat')<br />
What happens is sqlplus starts but it does not execute the script. No amount of quoting helps.<br />
<br />
It does always work like this :<br />
os.system('start callit.bat')<br />
However this opens another window and the python script resumes immediately. &nbsp;Using<br />
os.system('start /wait callit.bat') works exactly (wrong) as os.system('callit.bat'). It does wait but sqlplus starts up with no knowledge of the script, which contains the connect string.<br />
<br />
Any of you geniuses figure this one out?
</div>
</div>


I need to call Oracle Sql*Plus from a python script.  If I put the call to sql*plus like this:
os.system('sqlplus /NOLOG @my_script')
Then the @my_script will never get passed. Even if I put the line inside callit.bat and do:
os.system('callit.bat')
What happens is sqlplus starts but it does not execute the script. No amount of quoting helps.

It does always work like this :
os.system('start callit.bat')
However this opens another window and the python script resumes immediately.  Using
os.system('start /wait callit.bat') works exactly (wrong) as os.system('callit.bat'). It does wait but sqlplus starts up with no knowledge of the script, which contains the connect string.

Any of you geniuses figure this one out?

os.system() not passing command line properly

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.