SQL*Plus called from external process with prompt recognition
My question is a programmatically orientated one regarding SQL*Plus. We want to develop an application which uses the SQL*Plus console client to execute statements and scripts. To do this accurately we need to know whenever SQL*Plus wants an input from the user. So my question is how to determine whether SQL*Plus wants an input from the user or is busy?
Some technical background information:
We are working on Windows OS and using .NET as developing platform. The SQL*Plus console will be started within an .NET application as an process. The input and the output will be redirected, so the application can read out the result of SQL*Plus and can issue commands, statements and scripts to it. But it doesn't seem possible to find a clean solution whether SQL*Plus waits for input or not.