DBMS_SQL.LAST_ROW_ID Function

From: <larionov_at_yahoo.com>
Date: Tue, 16 Jun 1998 16:45:58 GMT
Message-ID: <6m67g6$m0c$1@nnrp1.dejanews.com>

Dear members of NG,

I am writing a procedure where I insert a row and I need to know immediately where I inserted it. So, I found the function DBMS_SQL.LAST_ROW_ID which returns the rowid of the last row processed.

I have a question about this function. Does it returns the last rowid for the current transaction, or the current session, or the current schema or for this instance? Is it transaction safe? Do I need to use some other functions in package DBMS_SQL or I can use LAST_ROW_ID just in the middle of a procedure wchoch contains no other functions from DBMS_SQL package?

Somebody had some negative experience using this function?

Thank you!

Michael.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 16 1998 - 11:45:58 CDT