Fetching sequence

[Shivraj]

hi

i have one client form in that form i can auto generate client id using sequence, then when i will click submit button, record is saved in database and another site dtl form open. In that site form i have taken one label and i want to show the client id on that label is it possible in java if yes then anybody help me for coding. my database is oracle.

[globaldelegation]

what is a dtl form? The database has nothing to do with it, unless you activate autosequence generation and you use that.
Be sure that you save the id associated with the user in the DB, and that you fetch it later with the same id (for example by matching with the user login )