This content has been marked as final. Show 4 replies
If you are trying to add this to a form item you need to use sequence.sequence_name.nextval.
How do you set this value ?
programatically or through the item property ?
I realise that previous answer could look a bit confusing so it should read
You may need to prefix "sequence" with a colon (:) I am not sure.
for assigning the sequence value to the form user field, i am using this way. try out this .
using select statement like this
Select sequence.nextval into :block.fieldname from dual
with some exception handling for the select statement.