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