Re: Changing ROWID

In <3f3m1c$evk_at_Starbase.NeoSoft.COM> csivils_at_Starbase.NeoSoft.COM (Craig Sivils) writes:

>
>In addition to the concern about the rowid changing, a seperate concern would be
>a row being deleted and a new row being assigned the same rowid. Some type of check
>would be required after retrieving a row to see you got what you think you wanted.
>
>Craig
>

Just to repeat a basic rule about ROWID:

ROWID is guaranteed for the duration of a transaction.

Under no circumstances should ROWIDs be kept and reused across more than one transaction...

-JJ

 Certified CDE2 Ambassador
 Powerswitch Partner
 IOCA Member

 Jeffrey Jacobs & Associates
 Oracle CASE Consulting and Training
 951-2 Old Country Road, Suite 119
 Belmont, CA 94002
 Voice: 415-571-7092
 FAX: 800-665-1379
 CompuServe: 76702,456
 Internet: jjacobs_at_well.com
 Internet: jmjacobs_at_ix.netcom.com   Received on Thu Jan 12 1995 - 20:49:48 CET