Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_SQL.LAST_ROW_ID Function
Isn't it simpler to see, if sql%rowcount<>0 after the
insert statement?
larionov_at_yahoo.com wrote in article <6m67g6$m0c$1_at_nnrp1.dejanews.com>...
> 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.
---
Alexander I.Doroshko, aid_at_grant.kharkov.ua