Re: os.system behavior when calling SQLPlus with spooling

2008-01-23 Thread Martin v. Löwis
> I would prefer not to use os.system() since I want to analyze the > results. Can anyone suggest how I should go about executing sqlplus > in this case? You need to find out why it hangs. Perhaps sqlplus tries to read from its stdin, asking the user for input, yet your script doesn't provide any

os.system behavior when calling SQLPlus with spooling

2008-01-23 Thread steve551979
I'm trying to execute SQLPlus in python (on Redhat linux). when calling sqlplus, i'm referencing an sql file which spools results to a file, for e.g.: spool "/tmp/qctemp2.out"; SELECT %s FROM bug WHERE BG_BUG_ID = %s; spool off; exit; I'm noticing that when using: os.system("sqlplus -S -L %s @