Re: How get the current value from a sequence?

In article <41ab8adf$0$29974$636a15ce_at_news.free.fr>, micadot{at}altern{dot}org says...

>1- To select a table in a procedure you must have been granted the select
privilege directly

Ahh, so the stored procedure has different privs, even if executed by the dba role?

>2- You can't get the real last value with this query as maybe there are values
in the cache

Yes, I am aware of that, but this is just an approximation stored in LAST_VALUE. I use a cache value of zero and increment by one, so it should be pretty accurate. Received on Tue Nov 30 2004 - 05:13:21 CST