Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_SQL.LAST_ROW_ID Function

Re: DBMS_SQL.LAST_ROW_ID Function

From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 19 Jun 1998 12:35:40 GMT
Message-ID: <01bd9b7e$2adc30e0$190114c1@sister.grant.UUCP>


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

Received on Fri Jun 19 1998 - 07:35:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US