> 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
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 @