How to grab the output from SQLPlus or Svrmgrl

From: harry <harry_h_tang_at_yahoo.com>
Date: Mon, 25 Mar 2002 19:49:52 GMT
Message-ID: <AbLn8.111110$af7.60617@rwcrnsc53>

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 - 13:49:52 CST