DBD::Oracle SQL query

mrras has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: DBD::Oracle SQL query by dthacker (Deacon) on Dec 27, 2002 at 22:43 UTC
As an Informix DBA, I'd use system to shut down the database locally and Expect.pm to shut it down remotely. Perhaps you could give us more details on the task you want to accomplish. Dave Code On!	[reply]
Re: DBD::Oracle SQL query by runrig (Abbot) on Dec 27, 2002 at 22:59 UTC
Has anyone been able to shutdown or startup an Oracle database using DBI. That is beyond the scope of DBI. It simply makes calls to the OCI (Oracle Call Interface). It can make calls to stored procedures, but you can't make a stored procedure that does what you want either.	[reply]
Re: DBD::Oracle SQL query by osama (Scribe) on Dec 28, 2002 at 13:02 UTC
why do it in dbi??? It's not portable to other databases anyway... try something like this... `open sqlplus,'\|sqlplus'; print <<THERE; system manager connect internal shutdown immediate quit THERE close sqlplus;` [download] make sure the user running the scripts is a dba... (for connect internal), or use another way.	[reply] [d/l]
Re: DBD::Oracle SQL query by mrras (Initiate) on Dec 27, 2002 at 23:10 UTC
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.	[reply]
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.	[reply]