Oracle Apex Conditional Link-CodePudding

I have a conditional link as follows:

case 
    when My_Flag = 'Y' then 
    '<a href="' || apex_util.prepare_url('f?p=&APP_ID.:65:&APP_SESSION.::&DEBUG.:65:
    :P65_MY_ID_ITEM,:P65_MY_ID_ITEM_2:' || TABLE_ID || ',' || TABLE_ID_2) || '"> 
    <p>Details</p>'
else
    '<a href="' || apex_util.prepare_url('f?p=&APP_ID.        :65:&APP_SESSION.::&DEBUG.:65::
    P65_MY_ITEM_3,:P65_MY_ITEM_4:' || TABLE_ID3 || ',' || TABLE_ID4) || '"><p>Details</p>'
end my_link

This link takes me to page 65 as intended but...items are not being populated. Any idea what might be happening?

Thanks!

CodePudding user response：

You may consider using the apex_page.get_url procedure to ensure your parameters are in the correct location. Currently you have an extra colon after the clear cache parameter.

I would also recommend using the :APP_SESSION bind variable in SQL instead of the substitution string, otherwise you'll blow out your SQL pool.