Re: Time to standardize the ``last insert id'' concept...

2003-03-12 Thread Tim Bunce
On Tue, Mar 11, 2003 at 01:30:30PM -0800, Michael Peppler wrote: It looks like it pays to question things. The following works, although I was sure it wouldn't: my ($sth, $sth2); $sth = $dbh-prepare(insert dbi_insert(c, i) values(?,?)); for(my $i = 0; $i 2; $i++) {

Re: Time to standardize the ``last insert id'' concept...

2003-03-12 Thread Michael Peppler
On Wed, 2003-03-12 at 03:11, Tim Bunce wrote: On Tue, Mar 11, 2003 at 01:30:30PM -0800, Michael Peppler wrote: It looks like it pays to question things. The following works, although I was sure it wouldn't: my ($sth, $sth2); $sth = $dbh-prepare(insert dbi_insert(c, i)

RE: Beta release of DBD::Oracle: DBD-Oracle-1.13-20030313.tar.gz

2003-03-12 Thread Jeff Urlwin
Tim -- I patched my version of oci7.c that I sent to you. I didn't download the version you had here. The basic problem I that some of the settings for ora_long, etc are moved to imp_drh and that the rest of the code assumes they are globals. Attached is a patch from oci7.c that makes things

RE: Beta release of DBD::Oracle: DBD-Oracle-1.13-20030313.tar.gz

2003-03-12 Thread Jeff Urlwin
Tim, Sorry -- you can ignore that last patch... I downloaded the beta and built it under Win32 and fixed t/cursor.t to not use the old connect style and skip the tests if OCI 7 is being used. This patch includes the prior patch. Regards, Jeff -Original Message- From: Tim Bunce

Re: Beta release of DBD::Oracle: DBD-Oracle-1.13-20030313.tar.gz

2003-03-12 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Mar 13, 2003 at 12:25:06AM +, Tim Bunce wrote: With many thanks due to Jeff Urlwin, I've been able to get back into DBD::Oracle development after 18 months of, er, stability! I've made a snapshot of what'll be in 1.13 and put it here:

RE: FW: Multiple Select statements in an SP and fetchrow_hashref

2003-03-12 Thread Jeff Urlwin
Yes. You're right that NAME_uc/NAME_lc and their *_hash variants need to be cleared from the cache. May actually be good to work the other way round... delete all cached attributes except a specific set. [Michael, I thought this might be interesting to you, if you haven't done this