in reply to DBD::Oracle SQL query

I am trying to shutdown abort. We do not care about the database state when it is time to shutdown the database. When I issue $dbh->do('shutdown abort');. I get not a valid sql statement. I do know this. but how do we trick DBI to think this is a sql statement.

Replies are listed 'Best First'.
Re: Re: DBD::Oracle SQL query
by runrig (Abbot) on Dec 27, 2002 at 23:19 UTC
    DBI doesn't care whether its a sql statement or not. It just hands it off to Oracle. Oracle doesn't like that non-sql statement. Do as the first reply says and use system and call sqlplus or something else.