I have a incremental field in a procedure, which needs to be incremented for each time when we execute the procedure.

for example: if you run the procedure for the first time

SRNO
1
2
3
4

if you run the procedure for the second time

SRNO
5
6
7
8

we need to implement this with in the same procedure with out sequence

Thanks in advance

I'm getting bit tired of asking this, but what is your db?
Oracle, sql server, firebird, db2, sqlite, postgresql, mysql.... ?

Second, what do you mean with

we need to implement this with in the same procedure with out sequence

?

my data base is oracle.

i want procedure for the above requirement