Thank you! This was very helpful.

I ended up getting the info from v$session that you mentioned then using dbms_rowid.rowid_create in my procedure to get the extended rowid.

Joel