RE: Using DBI to bounce the database

2005-09-08 Thread Andy Hassall
> Hi, group, I would like to bouce the database using DBI. AFAIK, "shutdown" and "startup" are SQL*Plus commands, therefore must be issued through SQL*Plus (or RMAN). They are neither SQL, DDL, nor session control statements, so cannot be issued via OCI, and therefore not through DBI/DBD::Oracle.

RE: Using DBI to bounce the database

2005-09-08 Thread Reidy, Ron
Joe, You should set RaiseError => 1 so you know what errors get thrown. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: joe bayer [mailto:[EMAIL PROTECTED] Sent: Thursday, September 08, 2005 2:05 PM To: dbi-users@perl.org Subject: Using DBI to bounce the database

Using DBI to bounce the database

2005-09-08 Thread joe bayer
Hi, group, I would like to bouce the database using DBI. #!/usr/bin/perl -w # # Purpose : Refresh user xxx from production # Created : 20050907 # Author :

DBD::ODBC and shared library

2005-09-08 Thread Vassiliy Truskov
Hello, I have a problem with the DBD::ODBC module (ODBC.sl) when ODBC driver manager is located in different directory, other then one was used at compilation time. The LD_LIBRARY_PATH, SHLIB_PATH and LD_RELOAD don't help. The error occurs at the startup time when 'use DBD::ODBC' calls. I rem

RE: DBD:ORACLE test failing

2005-09-08 Thread Reidy, Ron
Did you get errors from 'make'? Send the output of 'perl -V' and which C compiler are yopu using. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: raja agireddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 07, 2005 9:43 AM To: dbi-users@perl.org Subject: Fwd:

Fwd: DBD:ORACLE test failing

2005-09-08 Thread raja agireddy
-- Forwarded message -- From: raja agireddy <[EMAIL PROTECTED]> Date: Sep 7, 2005 11:28 AM Subject: DBD:ORACLE test failing To: modperl@perl.apache.org Hello! I have modepler2.0,Apache2.0.53 ,Perl5.8 on Sun OS 5.9. I have successfully installed DBI 1.48 and currently in the proce