Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: To find a just-inserted record

Re: To find a just-inserted record

From: Ed prochak <ed.prochak_at_alltel.com>
Date: 21 Dec 2001 09:40:26 -0800
Message-ID: <e51b160.0112210940.681a2005@posting.google.com>


S P Arif Sahari Wibowo <arifsaha_at_yahoo.com> wrote in message news:<Pine.LNX.4.42.0112210942380.28418-100000_at_macbeth.tirone.com>...
> Hi!
>
> Do you know how to make sure we can found a record that we just inserted?
>
> Obviously this is in programming context, a routine just execute an
> 'insert' sql command, but have to pass the rowid of that record to other
> routines. Obviously the rowid cannot be known before the record is
> inserted.
>
> Any idea how to keep a 'hold' on that newly inserted record?
>
> I try this on an Oracle 8.1.6 on Red Hat Linux using perl's DBI.
>
> Thank you!

here's a hint: think PRIMARY KEY. Received on Fri Dec 21 2001 - 11:40:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US