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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,398 views