Re: How to grab the output from SQLPlus or Svrmgrl

On Mon, 25 Mar 2002 19:49:52 GMT, "harry" <harry_h_tang_at_yahoo.com>  wrote:

In PROC- you can get the sqlerrm and the sqlcode out of the SQLCA.

>I tried to write a utility in C++ which needs to take the output from
>SQLPlus and/or Svrmgrl then present it to GUI. I write code such as:
>
>Assume: GMDBshutdown.sql is a shutdown scrip.
>
>char shutdownDBCmd[] = "svrmgrl @GMDBshutdown";
>returnVal = system(shutdownDBCmd);
>
>/* the execution result can be something as:
>"ORA-01034: ORACLE not available
>ORA-27101: shared memory realm does not exist"
>or
>"Database closed.
>Database dismounted.
>ORACLE instance shut down."
>
>I want to get the error code and text returned but the above way does not
>achieve the goal. Anyone knows how to get the returned text to the code?
>
>
Received on Mon Mar 25 2002 - 18:10:58 CST