APEX

ORA-01741: illegal zero-length identifier

Posted by : Saravanan   Introduction This Post demonstrates about error ORA-01741 : illegal zero-length identifier Scenario While adding multiple schemas to a single workspace, we get the following error in…

Read More

ORA-27492: unable to run job “APEX_040200.ORACLE_APEX_MAIL_QUEUE”: scheduler unavailable

Posted by Venkateshwaran Govindaraj ISSUE: ———- ORA-27492: unable to run job “APEX_040200.ORACLE_APEX_MAIL_QUEUE”: scheduler unavailable SOLUTIONS: —————— Alter system set job_queue_processes=1000;

Read More

ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property during Apex install in 12.2

Posted by Sathiyaseelan Mariappan Hi .. Lets find out the solution for below issue. Issue: Fresh apex install failed with the below error. ORA-38824: A CREATE OR REPLACE command may…

Read More

APEX INSTALLATION WITH HTTP(OHS) SERVER

APEX INSTALLATION WITH HTTP(OHS) SERVER Description: 1.We have to install first apex in our database after we have to install http(OHS) server: Apex Installation Unzip Apex files in specific PATH.…

Read More

USING APEX_ERROR NOTIFICATIONS TO MANAGE CUSTOM ERROR MESSAGES

Include User Notifications or Custom Messages and Error Messages in Oracle APEX’s default Success and Error Message style.  Default Success message : Default Error message : Steps in APEX :…

Read More

JQUERY AUTOCOMPLETE FOR TEXT FIELD ITEM IN ORACLE APEX

Process of enabling users to quickly find and select from a  list of values as they type, searching and filtering without Native text with auto-complete in APEX. This process works…

Read More

Creating Checkbox Tree In Oracle Apex 5.0

 Required Tools  vOracle Apex (Version 5) Step 1 Create Tree Region Sample code:                  SELECT   CASE             WHEN CONNECT_BY_ISLEAF = 1 THEN 0             WHEN LEVEL = 1 THEN 1             ELSE –1          END             AS status,          LEVEL,          Ename AS title,          NULL AS icon,…

Read More

Custom Excel Download with Chinese Characters (for languages other than English)

In APEX 4.2, reports with some Chinese and other language characters gets replaced with inverted question marks if downloaded. This issue can be fixed using the below method. Steps: 1…

Read More

EXCEL UPLOAD IN APEX USING SELECT LIST TEMPLATE

Follow the below steps to achieve, the process of uploading a .XLSX file with multiple tabs with Select List in APEX using PL/SQL.  ü  Step 1 : Create an .XLSX…

Read More

.XLSX UPLOAD IN APEX USING PL/SQL

Follow the steps below to achieve, the process of uploading a .XLSX file in APEX ( 4,5 AND 18C)  using PL/SQL.  ü  Step 1 : We need to create a…

Read More