1. Right Click on the File Browser item name and create a Validation Action
2. Then write this code as PL/SQL function body return text as condition
(Please replace the name of File Browser item name like "P15_RCAPPIMG_temp")
declare
cursor c is
select doc_size
from apex_application_files
where name = :P15_RCAPPIMG_temp;
v_size number := 0;
v_msg varchar2(100);
begin
open c;
fetch c into v_size;
close c;
--Here is 15360 means 15kb image size because 1 latter= 8 byte
if (v_size < 15360) then
v_msg := 'Image must be at least 15KB!';
DELETE from APEX_APPLICATION_FILES WHERE name = :P15_RCAPPIMG_temp;
return v_msg;
elsif (v_size > 30720) then
v_msg := 'Image size cannot be more than 30kb!';
DELETE from APEX_APPLICATION_FILES WHERE name = :P15_RCAPPIMG_temp;
return v_msg;
end if;
end;
Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Atlanta, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, OBIEE. Contact: qaiuminfo@gmail.com
Search This Blog
Subscribe to:
Post Comments (Atom)
Check Difference Between Two Database Objects
Step-1. Create Two DBLINK to connect with Two Database then Step-2. define logindb= DBLINKONE define remotedb= DBLINKTWO define schema_name=...
-
Search by keyword from Oracle Database Objects. select owner, type, name, line, text from dba_source where 1 = 1 and text like '%TEXT Y...
-
We Can Export Application Components individually from Oracle Apex. Application > Shared Components > Export Application Compo...
No comments:
Post a Comment