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!

checksum error

phani marellaDec 2 2010 — edited Feb 6 2011
Hi all..

APEX version: 3.2

I have a report which has a "link" that redirects the user to a specific page(with "page access protection : arguments must have checksum") and sets some values on that page. Everything was working fine as the "APEX" genarates the link with checksum.

Now i need to do some changes to the link and i am using apex_util.prepare_url to "manually" generate the link. I dont know why i am getting this checksum mismatch error. I tried with all the different types of checsums (3 (session), 2 and 1) types

This is the code i am using to generate the URL
select 
--*
<a href =  -- (i properly placed the href tags in my code. please dont consider this href tags)
(
APEX_UTIL.PREPARE_URL('f?p=159:4:'||&SESSION.||':LD:'||'NO'||':RP,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20:P4_ID1,P4_ID2,P4_ID3,
P2_ID4,P4_ACTION:'||tab1.id1||','||tab1.id2||','||tab1.id3||','||tab1.id4||','||'RESUME','utf-8','SESSION')
) 
ink,
please help me to find what i am doing wrong.
The checksum computed on the request, clear cache, argument names, and argument values (LD4567891011121314151617181920P4_PRIMPROCIDP4_PROCEDUREIDP4_PATIENTID
P2_PATIENTIDP4_ACTION1628831476714767RESUME 
[A80B0B235CEBA176F16C74867AA8B574] ) did not match the checksum passed into the show procedure (8010AF558F4F52E41F3AD9A9CD5621C0). 
i compared the links that generated by APEX and the one with apex_util.prepare_url . Everything looks exactly the same otherthan the "checksum".
I dont know why it is generating wrong cheksum (if i do it with apex_util.prepare_url)

Please help me to solve this issue.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2011
Added on Dec 2 2010
5 comments
1,508 views