RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Ron Savage
On Thu, 6 Oct 2005 14:00:58 +0100, Gaul, Ken wrote: Hi Ken Thanx. I'll try that tomorrow, at work. It's 11pm here now. -- Cheers Ron Savage, [EMAIL PROTECTED] on 6/10/2005 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Gaul, Ken
-Original Message- From: Ron Savage [mailto:[EMAIL PROTECTED] Sent: 06 October 2005 11:30 To: List - DBI users Subject: Oracle and dbh - last_insert_id Hi Folks I can't get last_insert_id() to work with Oracle. OS: GNU/Linux DBI: V 1.48 Oracle: 9.2.0 Demo (to save you typing):

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Hardy Merrill
Another alternative is to submit 2 queries - the first would be to retrieve the sequence nextval: SELECT [sequence name].NEXTVAL as my_seq_nextval FROM dual and the next would be the INSERT where you actually provide the value you just SELECT'ed. It does involve an initial SELECT query to

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread amonotod
From: Hardy Merrill [EMAIL PROTECTED] Date: 2005/10/06 Thu AM 08:43:09 CDT SELECT [sequence name].NEXTVAL as my_seq_nextval FROM dual Playing devils' advocate, in a busy environment there's no guarantee that the result of that query is the value that will be used for the subsequent

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Ronald J Kimball
amonotod [mailto:[EMAIL PROTECTED] wrote: SELECT [sequence name].NEXTVAL as my_seq_nextval FROM dual Playing devils' advocate, in a busy environment there's no guarantee that the result of that query is the value that will be used for the subsequent insert. The query with the

Re: Oracle and dbh - last_insert_id

2005-10-06 Thread Ron Savage
On Thu, 6 Oct 2005 15:22:24 +0100, Tim Bunce wrote: Hi Tim, and others Firstly, thanx for the responses. That's because it's not implemented. Patches welcome - but I suspect it's non-trivial. I assume the problem is determining (ie asking Oracle to determine) the relationship between the

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Ron Savage
On Thu, 06 Oct 2005 09:43:09 -0400, Hardy Merrill wrote: Hi Hardy SELECT [sequence name].NEXTVAL as my_seq_nextval FROM dual Sure, but when you are calling Class::DBI's 'create' you are another step removed from the insert statement itself. So what to Class::DBI users do in such a case? --

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Ron Savage
On Thu, 06 Oct 2005 09:43:09 -0400, Hardy Merrill wrote: Hi Hardy SELECT [sequence name].NEXTVAL as my_seq_nextval FROM dual Also, is this really any different from calling seq.currval after the insert? I assume not. -- Cheers Ron Savage, [EMAIL PROTECTED] on 7/10/2005

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Steve Baldwin
you can retrieve the package variable in a separate anonymous PL/SQL block. If you need more info, let me know and I will provide an example. Steve -Original Message- From: Ron Savage [mailto:[EMAIL PROTECTED] Sent: Friday, 7 October 2005 8:07 AM To: List - DBI users Subject: RE: Oracle

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Ron Savage
On Fri, 7 Oct 2005 08:24:22 +1000, Steve Baldwin wrote: Hi Steve (Apologies for top-posting ...) No problem. It's the norm in the mod_perl list, but still distresses some people. In most cases there will be no difference, but it is possible for triggerbased logic to subsequently bump the

RE: Oracle and dbh - last_insert_id

2005-10-06 Thread Steve Baldwin
Hi Ron, See below ... -Original Message- From: Ron Savage [mailto:[EMAIL PROTECTED] Sent: Friday, 7 October 2005 9:09 AM To: List - DBI users Subject: RE: Oracle and dbh - last_insert_id On Fri, 7 Oct 2005 08:24:22 +1000, Steve Baldwin wrote: Hi Steve (Apologies for top-posting