Re: how to shutdown immediate in Pro*C

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 28 Apr 2006 13:33:42 GMT
Message-ID: <1146231221.2163@proxy.dienste.wien.at>

sl <susanzlam_at_yahoo.com> wrote:
> I would like to call 'shutdown immediate' in my proc program but I
> could not figure how to do it. Tried calling it using EXEC SQL but it
> failed with
> "ORA-00900: invalid SQL statement".

You cannot do this with embedded SQL.

SHUTDOWN is not an SQL command, it is an SQL*Plus command.

To shutdown an Oracle database from C, use the OCI interface.

Yours,
Laurenz Albe Received on Fri Apr 28 2006 - 08:33:42 CDT