Oracle Apex Users can change the status filed on a record from a List of VAlues. Value is not saving when changed
Posted on 2008-10-07
Users are allowed to change the status of an item from a LOV in a drop down list. They change this value from the drop down and hit the apply change button. However, this does not work. The status is not changed.
The code for the LOV array is as follows:
update TABLE SET STATUS_FLAG = htmldb_application.g_f01(1) where doc_no = :P_doc_no;