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!

Concatenating a Page Item value or a workflow variable value to rest data source parameter.

Hello Community,

I have a workflow designed for my application. In that I am using an Execute Code Activity. In that Execute Activity Code I am having the Code as below. Similarly, I want to concatenate a page item's value (generated by sequence) to once of the rest data source parameter in the below format. So, let's assume PXX_ID is Mapped to Workflow parameter (ID) in the Page Process. So, PXX_ID will assign value to ID. Though all of this is setup I am getting the expected output.

Expected Output: Description - 20

Please let me know if I miss any steps.

@steve-muench-oracle please let me know if you have any solution for this.

declare
    l_parameters apex_exec.t_parameters;
begin
    -- Add any "IN" parameters
    apex_exec.add_parameter(
       p_parameters => l_parameters,
       p_name       => 'sampleDesc',
       p_value      => :sampleDesc || '-' ||:ID );
Comments
Post Details
Added on Jun 4 2025
1 comment
163 views