Re: DBD::Pg - send arrays to a stored procedure

2005-01-20 Thread Dmitry Karasik
Hi Rudy! On 18 Jan 05 at 14:30, Rudy (Rudy Lippan) wrote: Rudy Do a recursive traversial of the array and turn it into a string Rudy with elements surrounded with ''s and separated by ','s, with Rudy dementions delimited by '{}' pairs and separated by ','s. And of Rudy course, you

Re: DBD::Proxy breaking die within eval strangeness

2005-01-20 Thread Tim Bunce
On Wed, Jan 19, 2005 at 05:37:42PM -, Addison, Mark wrote: Hello, I'm having a very strange problem with DBD::Proxy and have ended up with brain meltdown - so now its your turn ;-) Here's a patch... Tim. Index: t/80proxy.t

Re: 2 cursors? at the same time

2005-01-20 Thread Hardy Merrill
Hi Nina, A couple of things: 1. Where in the perldocs did you find the part about setting AutoCommit off would fix your problem? Was that in DBD::Ingres? I haven't used DBI in a while, but I don't remember having a problem using a database connection with one statement handle

DBI connections to oracle sometimes hang

2005-01-20 Thread David Goodman
On occassions when an oracle instance is having trouble, my DBI connections hang. For example, if the oracle archive log destination is full or the OS itself is hung, the DBI connection will also hang. With DBI's trace level 3, it remains hung on the following: - connect for DBD::Oracle::dr

RE: DBI connections to oracle sometimes hang

2005-01-20 Thread Reidy, Ron
You could set up a SIG{ALARM} and the attempt the connection. Or better still, get your DBAs to fix the problems in the DBs. - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: David Goodman [mailto:[EMAIL PROTECTED] Sent: Thursday, January 20, 2005

RE: DBI connections to oracle sometimes hang

2005-01-20 Thread Hardy Merrill
I've never done this, but Ron's advice ($SIG{ALRM}) is in line with the DBI perldocs. Here is a snippet from 'perldoc DBI' - I searched for timeout: Signal Handling and Canceling Operations The first thing to say is that signal handling in Perl is currently *not* safe. There is always