S P Arif Sahari Wibowo wrote:
>
> 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!
>
> --
> S P Arif Sahari Wibowo
> _____ _____ _____ _____
> /____ /____/ /____/ /____ arifsaha_at_yahoo.com
> _____/ / / / _____/ http://www.arifsaha.com/
Look at the 'RETURNING' clause for the insert statement.
--
Ron Reidy
Oracle DBA
Received on Fri Dec 21 2001 - 14:10:26 CST
