This discussion is archived
3 Replies Latest reply: Apr 4, 2013 5:26 AM by VC RSS

APEX_UTIL.GET_BLOB does anyone know how to calculate the checksum?

DF777 Newbie
Currently Being Moderated
Hi!


Does anyone know how to calculcate the checksum for the APEX_UTIL.GET_BLOB-Link?
<a href="apex_util.get_blob?s=2040766138999284&a=500&c=2963523354500419&p=7030&k1=1841200&k2=&ck=E369F782D77061F0FEAC0BB42EC5E63B&rt=IR">
  <img width="30px" src="wwv_flow_file_mgr.get_file?p_security_group_id=2444012387079848&p_fname=download.png">
</a>
the "ck" parameter: ck=E369F782D77061F0FEAC0BB42EC5E63B

Thx!

PS: Yes I know the APEX_UTIL.GET_BLOB_FILE_SRC-Function, but I like the easy way, that's why I am using APEX ;)
  • 1. Re: APEX_UTIL.GET_BLOB does anyone know how to calculate the checksum?
    VC Guru
    Currently Being Moderated
    What is your apex version??
    DF777 wrote:
    Hi!


    Does anyone know how to calculcate the checksum for the APEX_UTIL.GET_BLOB-Link?
    Try wraping your above API call with APEX_UTIL.PREPARE_URL
    http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35127/apex_util.htm#CDEIBCJD
    <a href="apex_util.get_blob?s=2040766138999284&a=500&c=2963523354500419&p=7030&k1=1841200&k2=&ck=E369F782D77061F0FEAC0BB42EC5E63B&rt=IR">
    <img width="30px" src="wwv_flow_file_mgr.get_file?p_security_group_id=2444012387079848&p_fname=download.png">
    </a>
    the "ck" parameter: ck=E369F782D77061F0FEAC0BB42EC5E63B

    Thx!

    PS: Yes I know the APEX_UTIL.GET_BLOB_FILE_SRC-Function, but I like the easy way, that's why I am using APEX ;)
    you mean that this api is not easy??
  • 2. Re: APEX_UTIL.GET_BLOB does anyone know how to calculate the checksum?
    DF777 Newbie
    Currently Being Moderated
    When I try in an PL/SQL Region

    select APEX_UTIL.PREPARE_URL('apex_util.get_blob?s=2040766138999284a=500c=2963523354500419p=7030k1=1841200k2=','UTF-8','SESSION')
    from dual

    i get the input URL "apex_util.get_blob?s=2040766138999284a=500c=2963523354500419p=7030k1=1841200k2=" returned without any ck-"Tag"


    Maybe that's the reason: p_url has to be an f?p relative URL with all substitutions resolved

    Edited by: DF777 on 04.04.2013 03:53
  • 3. Re: APEX_UTIL.GET_BLOB does anyone know how to calculate the checksum?
    VC Guru
    Currently Being Moderated
    DF777 wrote:
    When I try in an PL/SQL Region

    select APEX_UTIL.PREPARE_URL('apex_util.get_blob?s=2040766138999284a=500c=2963523354500419p=7030k1=1841200k2=','UTF-8','SESSION')
    from dual
    Don't you have to do something like?:
    select APEX_UTIL.PREPARE_URL(APEX_UTIL.GET_BLOB_FILE_SRC('P2_ATTACHMENT',:P2_EMPNO))  from dual      
    i get the input URL "apex_util.get_blob?s=2040766138999284a=500c=2963523354500419p=7030k1=1841200k2=" returned without any ck-"Tag"

    Maybe that's the reason: p_url has to be an f?p relative URL with all substitutions resolved
    May be, nut I can see the ck parameter in get_blob_file and get_blob sub programs

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points