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;
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…