Depends if you take the OP's questions literally. If you want to use a proc to find out the sequence's nextval then you need to do it that way. You could just select in form dual normally without doing a proc - all depends on what the OP actually wants On 8/23/05, Ram K <lambu999@xxxxxxxxx> wrote: > Cant we select directly from a sequence without having to use a > function? Is there any advantage to using a function? -- //www.freelists.org/webpage/oracle-l