Re: reading sequence.CURRVAL

er... Pardon my asking but can't you read the max value from the table and compare it to the previous max to see if new rows have been added ?

Venkat

>I'm using Oracle 7.3..3, and I want my app to check every now and then
>to see if new records have been added to a table (without using
>triggers).
>
>What I'd like to do is just read sequence.CURRVAL, where
>this is a sequence that generates record IDs for the table. If CURRVAL
>has
>increased since the last time I read it, I know there are new records,
>and what range their IDs are in.
>
>But the documentation says "Note that before you use CURRVAL
>for a sequence in your session, you must first initialize
>the sequence with NEXTVAL." And it is true; I've tested it.
>
>This means that I can't just read CURRVAL; first I have to
>reference NEXTVAL, which increments the value ! I don't want
>to do this.
>
>Is there any other way to read CURRVAL without changing its value ?
>
>I can't believe sequences have this behavior !
Received on Thu Apr 23 1998 - 17:06:07 CDT