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!

How would I concatenate text from a page item with no source to the end of a column?

APEX_DOUCESep 13 2022

Hello yall,
I am using APEX 20.1.
I have a "Comments" column that needs to have comments concatenated to the end of the column but not replace what is already there.
Each time I try & run the process I keep getting the error: "Error processing process."
When viewing the debug it also states that there is a numeric or value error.

Here is the general pl/sql I have tried using:
update table
set comments = (comments || :P1_COMMENTS_UPDATE)
where ID = :P1_ID;
The :P1_COMMENTS_UPDATE page item does not have a source. Is this the error?

Any help would be greatly appreciated.

Thank you,
Derek

This post has been answered by APEX_DOUCE on Sep 13 2022
Jump to Answer
Comments
Post Details
Added on Sep 13 2022
1 comment
177 views