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
Md. Quium Hossain who I'm Oracle DBA & APEX Developer. All-rounder in building small, medium, and enterprise applications. Extensive knowledge in various areas of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, Oracle Forms, Oracle Reports, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, SMS, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)
Subscribe to:
Post Comments (Atom)
How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10
#########################Install Oracle APEX 24.1################################ ----------------------------------------------------...
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment