I am populating a select list with member names with an lov sql similar to the following
<tt>select memberName d, memberId r FROM whateverTable</tt>
The problem is that in the database the value stored is the memberId. I really want the actual memberName stored in the database instead as I would like to use this member name elsewhere in my app.
When the built in trigger executes its code
<tt>
if nvl(:old.CONTACT_PERSON,'0') != nvl(:new.CONTACT_PERSON,'0') then
insert into eba\_ca\_history (table\_name, component\_rowkey, COMPONENT\_ID, column\_name, old\_value, new\_value) values
('EVENTS', :new.row\_key, :new.event\_id, 'EVENT\_OWNER',:old.CONTACT\_PERSON,:new.CONTACT\_PERSON);
end if;
</tt>
I get the following shown on my apps update page -- "Event Owner changed from 457879885611315631565 to 2546454654546546546546...."
I want the actual display value to be shown for an update instead of the return value.
I tried to convert the value using
But that results in the following error
How can I make sure the return value of the lov being stored in the database matches the display value of the lov???