RE: PERL?

From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 10 Dec 2003 07:44:27 -0800
Message-ID: <F001.005D9709.20031210074427@fatcity.com>

Jared,

Thanks for correcting me that shutdown is a sqlplus command. I wanted to make the point that piping strings to sqlplus can do more than Perl DBI can. (But Perl DBI has advantages in many cases)

Yong Huang

Jared.Still_at_radisys.com wrote:

All *SQL* commands will work work with the DBI.

'SHUTDOWN' is not a SQL command, it is a sqlplus command, and therefor will not work with the DBI.

This has been checked into, and Oracle does not make this functionality available
via OCI, so shutting down and starting a database on *nix requires sqlplus.

Here is one of the few instances where Win32 makes things easier than on *nix: Oracle can be stopped and started via a service, which means you can easily shut it down via the command line, and via the Win32 Perl module Win32::Service.

If you want in depth discussion on this check the archives for the dbi-users list.

I don't recall where the archives are, but the list is found at lists.perl.org.

Jared

Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Yong Huang
INET: yong321_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Dec 10 2003 - 09:44:27 CST