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!

Append Data From A Lookup To An Existing Column - APEX 5.1

Joe RJun 14 2017 — edited Jun 16 2017

Version: 5.1.1.00.08

Hello,

Background

I have a lookup table that contains character strings that are stubs that the user will enter and a process will return the actual text that the stub represents.

As an example if the user enters a stub like 'ffatm' the process will look at this lookup table and return '7g/24h'. This is just an example the return strings can be up to 500 characters, hence the reason they want this lookup table.

I'm thinking of a text box with a button to run the page process that will lookup the stub entered and return the string.

Issue

I have an Interactive Grid with a clob column. As the user is entering text they want to enter this stub (into a text box that is above the Interactive Grid region click the button) to return the actual string that they want to enter.

I want to add this return string at the end of whatever is already entered in this clob column on the Interactive Grid but I have no idea how.

Can someone help me achieve this?

Please let me know if this is not clear.

Thanks,

Joe

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2017
Added on Jun 14 2017
2 comments
376 views