SQL*Plus (MOSC)

MOSC Banner

SQL*Plus called from external process with prompt recognition

edited Jun 16, 2010 7:05AM in SQL*Plus (MOSC) 5 commentsAnswered
Hello everyone.

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center