Monday, March 11, 2019

how to create image gallery with plugins

plugins link
https://apex.world/ords/f?p=100:710:15283332136545::::P710_PLG_ID:IMAGE.GALLERY.DE.NHASKO

create table image
(
ID                                                 VARCHAR2(10),
IMAGE_ID                                           VARCHAR2(50),
FILENAME                                           VARCHAR2(100),
MIME_TYPE                                          VARCHAR2(100),
CONTENT                                            BLOB,
LAST_UPDATE                                        DATE,
CHARACTER_SET                                      VARCHAR2(30)
)
--enter image in table

Application Items
FILE_ID

application process
Ajax Callback: Run this application process when requested by a page process.

paste code

begin
for c1 in (select *
             from image
            where id = :FILE_ID) loop
    --
    sys.htp.init;
    sys.owa_util.mime_header( c1.mime_type, FALSE );
    sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( c1.content));
    sys.htp.p('Content-Disposition: attachment; filename="' || c1.filename || '"' );
    sys.htp.p('Cache-Control: no-cache'); 
    sys.owa_util.http_header_close;
    sys.wpg_docload.download_file( c1.content );

    apex_application.stop_apex_engine;
end loop;
end;


create region & set plugins & paste source
create item P61_ID

select 'f?p=&APP_ID.:0:&APP_SESSION.:APPLICATION_PROCESS=GETFILE:::FILE_ID:'||IMAGE_ID SHOW_IMAGE,
  FILENAME FILENAME,
  IMAGE_ID IMAGE_ID,
  APEX_UTIL.PREPARE_URL(
    p_url => 'f?p=' ||:APP_ID || ':4:'||:APP_SESSION||'::NO::P61_ID:'||IMAGE_ID,
    p_checksum_type => 'SESSION') IMAGE_URL
from image

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