Hi
I'm trying to set a default value for a page items.It works with all types except sequence.
I tried to enter the sequence name only (EMP_SEQ) not working. and also (EMP_SEQ>NEXTVAL).
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Yes, you are right. If we specify only the sequence name, it is not working. You can select the Default type as Expression and then choose language SQL or PL/SQL and then specify the expression as below:
This will work.
Eyad
Thank you.
I noticed that
The type sequence works only with primary key Page item.