Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Tabular Form - Extra Column

143894Aug 26 2008 — edited Aug 26 2008
I have a tabular form on HR schema's Employees table.
On the Department Field I want to place an Popup LOV (not select list).
But the problem is since the table has department ID field and not the department name, the LOV has to return Department ID although it shows Department name when the LOV is open.
I don't want to show department ID on form but want to show department name. And department ID should be on the back (hidden field). Therefore I made an extra column with the name DEPARTMENT which is non-database column (no table reference)
I wrote a a process which fires On Submit after validation and computation which seeks department_id from the table on the basis of what was selected from the list and assigns department id to the hidden field in the tabular form.

The problem comes when I try to submit the form it raises an error

Error in mru internal routine: ORA-20001: Error in MRU: row= 0, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "4EB6AAF3C9315880CCB50CD7E9F580D7", item checksum = "C6D68DEE14C198A67CAF47BA7CADB9E8".,



Line: -----
My code of the process is


DECLARE
v_department VARCHAR2(10);
BEGIN

FOR i IN 1.. HTMLDB_APPLICATION.G_F07.COUNT LOOP


SELECT d.department_id
INTO v_department_id
FROM departments d
WHERE d.department = HTMLDB_APPLICATION.G_F15(i);

HTMLDB_APPLICATION.G_F07(i) := v_department_id;

END LOOP;

END;

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 23 2008
Added on Aug 26 2008
2 comments
354 views