Create a Funtion to Increment a 7 digit number and call it from a stored proc

[DICHPALLY]

Hi,

I need to create a function to generate a sequence of unique seven digit numbers and store the next value for future references and call this function from with another stored proc in Oracle. Can anyone give me some guidance on this? Thanks.

--Raj

[debasisdas]

why don.t you create a sequence instead of writing a function .