3 Replies Latest reply: Apr 4, 2013 7:26 AM by VC RSS

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

    DF777
      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
          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
            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
              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