Future versions of DBI to require perl = 5.8

2006-01-25 Thread Tim Bunce
FYI I'm planning on making the next release (1.51) be the last that officially supports perl 5.6. This is partly to make it easier to implement changes in future releases that improve performance with threaded perls. This will benefit ActiveState perl users, people using DBI with mod_perl2, and

Re: Having problems setting up DBD::ODBC

2006-01-25 Thread Mark Nettleingham
Jeff, Well, I feel really silly about that one, setting LD_LIBRARY_PATH makes things much better. However, I'm still getting failures. The current test failure looks like this: t/02simple...ok 2/36DBI connect('UpdatesDatabase','gbuilder',...) failed: [iODBC][Driver Manager]Data

Statement handle side effects of swap_inner_handle?

2006-01-25 Thread Steven Lembark
I'm using swap_inner_handle in a HandleError sub to re-connect the existing database handle. The trick is to re-connect if the error warrants it, return false to the caller, which then allows the caller to re-try the failed operation and keep going. Q: Do I need to use $if_active = 3 to

Re: large updates and deletes

2006-01-25 Thread Steven Lembark
-- Robert Hicks [EMAIL PROTECTED] Steven Lembark wrote: -- Robert Hicks [EMAIL PROTECTED] I have been handed a couple of requests to change some data. One is an update on 3.6 million records and the other is two different deletions of over 16 million rows of data. I need to be able to

Re: Possible extension for DBI error handler (fwd)

2006-01-25 Thread Steven Lembark
-- Tim Bunce [EMAIL PROTECTED] $dbh-connect_cached( @{ $meta{ $dbh } } ); If the connection has failed then connect_cached() will return a new, different, $dbh which would be lost with the code above. To change the $dbh in the application to be this new $dbh you'd need to

Re: Possible extension for DBI error handler (fwd)

2006-01-25 Thread Tim Bunce
On Wed, Jan 25, 2006 at 02:51:14PM -0500, Steven Lembark wrote: -- Tim Bunce [EMAIL PROTECTED] $dbh-connect_cached( @{ $meta{ $dbh } } ); If the connection has failed then connect_cached() will return a new, different, $dbh which would be lost with the code above.

Re: Statement handle side effects of swap_inner_handle?

2006-01-25 Thread Tim Bunce
On Wed, Jan 25, 2006 at 02:42:18PM -0500, Steven Lembark wrote: I'm using swap_inner_handle in a HandleError sub to re-connect the existing database handle. The trick is to re-connect if the error warrants it, return false to the caller, which then allows the caller to re-try the failed

DBI DBD::Oracle help

2006-01-25 Thread Natesh Kedlaya
Hi, How can I bind an Perl array to a PL/SQL function's input/output that take PL/SQL associative arrays? For Example; In the following PL/SQL function: function my_func ( p_1 in my_coll , r_1 out my_coll ) return pls_integer; The my_coll is a PL/SQL associative array

Re: Statement handle side effects of swap_inner_handle?

2006-01-25 Thread Steven Lembark
The inner handle carries all the DBI info, including CachedKids. So swap_inner_handle is a simple and total brain transplant. Q: Any chance of getting $sth-clone? From what I can see in the doc's, the clone method is specific to database handles (the statement's clone would account for

DBD::ASAny

2006-01-25 Thread nyem
I'm using DBD::ASAny on my development machine (win2000) but when I copied them to the production server (win2003) I got this error: install_driver(ASAny) failed: Can't load 'H:/perl/site/lib/auto/DBD/ASAny/ASAny .dll' for module DBD::ASAny: load_file:The specified module could not be found