os.system behavior when calling SQLPlus with spooling

["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?

You can use "strace -p <id of sqlplus>" to find out what it's doing
when it hangs.

Regards,
Martin