1 Reply Latest reply on Nov 14, 2017 5:08 AM by MD. MASUD

    Oracle APEX  5.1.2  How can i retrieve image shear drive / another PC

    MD. MASUD

      How can i retrieve image or directory

      which is located shear drive from another pc like

      (create directory image_dir as '\\192.100.0.05\smb\image';)

      * When run (user_name/Password) need Application

      1. How & where i place (user_name/Password) in process?

      2. How I pass the share pc (user_name/Password) for retrieve 'IMAGE_DIR' directory  From Oracle APEX application?

       

      Any one tell me please .

      Process

      ========================================

      DECLARE

        v_img     BFILE;

        v_get  NUMBER;

      BEGIN

      --

        l_img :=  BFILENAME('IMAGE_DIR', :REQUEST);

        l_length := DBMS_LOB.getlength(v_img);

        --

        htp.flush;

        htp.init;

        --

        htp.p('Content-length: ' ||   v_get);

        --

        htp.p('Content-Disposition: inline; filename="&REQUEST."');

        --

          owa_util.http_header_close;

        --

          wpg_docload.download_file(v_img);

      --

      END;

       

      The code credit : Jari Laine

       

      =====================================================

      Error

      ORA-22288: file or LOB operation FILEOPEN failed The specified network password is not correct.

       

       

      Technical Info (only visible for developers)

      • is_internal_error: false
      • ora_sqlcode: -22288
      • ora_sqlerrm: ORA-22288: file or LOB operation FILEOPEN failed The specified network password is not correct.
      • component.type: APEX_APPLICATION_PAGE_PROCESS
      • component.id: 21419207583941937
      • component.name: New
      • error_backtrace:
        ORA-06512: at "SYS.WPG_DOCLOAD", line 89 ORA-06512: at line 25 ORA-06512: at "SYS.DBMS_SQL", line 1575 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1880 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1895 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 936 ORA-06512: at "APEX_050100.WWV_FLOW_PROCESS_NATIVE", line 71 ORA-06512: at "APEX_050100.WWV_FLOW_PROCESS_NATIVE", line 1132 ORA-06512: at "APEX_050100.WWV_FLOW_PLUGIN", line 2399 ORA-06512: at "APEX_050100.WWV_FLOW_PROCESS", line 200

       

      Error.PNG