Jason Jay Weiland <archduke_at_uclink4.berkeley.edu> wrote in article
<36374567.ACD9F75C_at_uclink4.berkeley.edu>...
> Ken,
>
> Try using CURRVAL to find maximum number
> generated from your sequence. You can also get
> additional details from the USER_SEQUENCE table.
You can't use CURRVAL without previously issuing NEXTVAL in the
current session. Grinberg L. article in this discussion solves the
problem completely.
---
Alexander I.Doroshko, aid_at_grant.kharkov.ua
- Bank "Grant", Kharkov, Ukraine
Received on Thu Oct 29 1998 - 03:34:08 CST
