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 pass the values containing a space in parameter via url

Soukaina IDRISSIAug 16 2018 — edited Aug 28 2018

Hi everyone,

I created one link url, via sql query like this:

'f?p='||:APP_ID||':300:'||:APP_SESSION|| '::NO:RP,300:P300_FLD_ID,P300_FLD_PARENT,P300_NAME_CUST,P300_TRIBUNAL:'  
||apex_escape.html(f.FLD_ID)|| ',' 
||apex_escape.html(d.FLD_PARENT)|| ',' 
|| d.FNAME_CLIENT || ' ' 
|| d.LNAME || ',' 
|| f.TRIBUNAL

And i get this result

P300_FLD_ID,P300_FLD_PARENT,P300_NAME_CUST,P300_TRIBUNAL:10904,3115000%20/%2003115001%20/%20203115002,%20STE%20SARL%20ABC,081

that doesnt works, with ORA-01403: Not Data Found, when i load data from view .

And when i tape manually this link:

P300_FLD_ID,P300_FLD_PARENT,P300_NAME_CUST,P300_TRIBUNAL:10904,3115000%20/%203115001%20/%203115002,STE%20SARL%20ABC,081

I get data from the page.

So how can i fixe this issue ?

Thank you for help.

This post has been answered by fac586 on Aug 16 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2018

Added on Aug 16 2018

#apex-discussions, #url

6 comments

3,062 views