Re: Deadlock & DBMS_ROWID weirdness.
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Thu, 3 Jan 2019 13:40:06 +0000
Message-ID: <3503bada-3517-dc9e-94c9-40c4bcc8dc3d_at_dunbar-it.co.uk>
Date: Thu, 3 Jan 2019 13:40:06 +0000
Message-ID: <3503bada-3517-dc9e-94c9-40c4bcc8dc3d_at_dunbar-it.co.uk>
On 03/01/2019 11:11, Mladen Gogala wrote:
> Your problem is in the fact
> that dbms_rowid.rowid_object doesn't return object id, it returns
> data_object_id.
Brilliant Mladen, that's exactly it - thanks.
The OBJECT_ID for this table is indeed not the same as the DATA_OBJECT_ID but the latter is the one that DBMS_ROWID is returning. Problem now solved. (And today's "learning something new" ticked off the list!)
Much appreciated, thanks.
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 03 2019 - 14:40:06 CET