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 to remove escaped characters like %20 from passed parameter

indy2005Jul 5 2019 — edited Jul 5 2019

Hi,

I am passing parameters with spaces between pages. How can I remove the %20 values which are being bound to the target page item?

select

'Despatched MAAs' as label,

(SELECT COUNT(DISTINCT LU_NUMBER) FROM V_GRET_LU_STATUS_DATES

WHERE DRUG_PRODUCT_ID IN (SELECT DRUG_PRODUCT_ID FROM GRET_PRODUCTS WHERE GRET_ID = :P5_GRET_ID)

AND LU_CATEGORY IN ('Marketing Application New Dosage Form','Marketing Application New Product','Marketing Application New Strength')

AND LU_STATUS = 'Despatched') as value,

APEX_PAGE.GET_URL (

p_page => 7,

p_items => 'P7_GRET_ID,P7_LU_CATEGORY_1,P7_LU_CATEGORY_2,P7_LU_CATEGORY_3,P7_LU_CATEGORY_4,P7_LU_CATEGORY_5,P7_LU_STATUS',

p_values => :P5_GRET_ID || ',Marketing Application New Dosage Form,Marketing Application New Product,Marketing Application New Strength,,,Approved') as url

from dual

Is giving me target page items of: Marketing%20Application%20New%20Dosage%20Form

Thanks

Stephen

Added on Jul 5 2019

#apex-discussions

2 comments

952 views