Wednesday, September 25, 2019

How to show profile picture in top right Conner in oracle apex


1. Table Scripts
 create table emp1
 (
  EMPNO                                              NUMBER(4)
 ,ENAME                                              VARCHAR2(10)
 ,HIREDATE                                           DATE
 ,IMAGE                                              BLOB
 ,IMG_TYP                                            VARCHAR2(100)
 ,IMG_NM                                             VARCHAR2(100)
)


2. Create application item in sharecomponnent
Name          :  FILE_ID
Condition     : Unrestricted

3. Create Application Processes

Name          : GETIMAGE
Process Point : Ajax Callback: Run this application process when requested by a page process.

PL/SQL Anonymous Block Code


begin
    for c1 in (select * from emp1
                where EMPNO = :FILE_ID) loop
        --
        sys.htp.init;
        sys.owa_util.mime_header( c1.img_typ, FALSE );
        sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( c1.IMAGE));
        sys.htp.p('Content-Disposition: attachment; filename="' || c1.img_nm || '"' );
        sys.htp.p('Cache-Control: max-age=3600');  -- tell the browser to cache for one hour, adjust as necessary
        sys.owa_util.http_header_close;
        sys.wpg_docload.download_file( c1.IMAGE );
   
        apex_application.stop_apex_engine;
    end loop;
end;

4.
Shared ComponentsList\ Details\ Create Entry
Template : Nabigation Bar
         : Check Transalator
first row paste
<img style="width:42px;height:42px;border-radius: 50px;" class="t-Icon a-Icon" src="f?p=&APP_ID.:0:&APP_SESSION.:APPLICATION_PROCESS=GETIMAGE:::FILE_ID:&APP_USER.">

Thanks


//or
<img style="width:30px;height:30px;" class="t-Icon a-Icon" src="f?p=&APP_ID.:0:&APP_SESSION.:APPLICATION_PROCESS=GETIMAGE:::FILE_ID:&APP_USER.">



Theme Roller  CSS for remove background box in oracle apex...

.t-Button--navBar .t-Button-badge { border-radius: 16px; background-color: #0076df; }



No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...