db11gxe , apex 4.0 , firefox 24 ,
hi all ,
i have a check box and a number item ,
what i want is
when the check box changes , the nextval of the dept_seq sequence is inserted into the number item .
i created a dynamic action on the check box of type pl\sql and wrote this
select dept_seq.nextval into :p9_n from dual ;
page items to submit , p9_n without the colon .
but i only can see one number of the sequence when i load the page , and when i check or uncheck the checkbox , i see nothing ??
why ?
thanks