Skip to main content

Posts

How to set Modal Dialog Title in Oracle APEX? JavaScript

 At times, the same modal dialog page is used to add as well as to edit a record. In such circumstances, a user-friendly title enhances the UX.  Updating non-modal dialog page title For a non-modal dialog, this is pretty straightforward. A substitution string can be used to dynamically set the title. For example, the page title in this scenario is set to Vendor display name. This is achieved by updating the title attribute. However, this approach will not work for modal dialogs. We can use javascript to update the modal dialog title. Updating Modal Dialog Title On page load, use a dynamic action to set the dialog title. .m-dialog-content CSS class is optional. This is used to avoid updating the title of the parent dialog in scenarios where a modal page opens another modal page. Output Edit Add
Post a Comment
Read more
Recent posts

Installing and Configuring Oracle Apex 20.1 and Deploy ORDS in Apache Tomcat - Windows

This post along with the demo video briefly explains the steps involved in installing Oracle Apex 20.1 and configuring ORDS. ORDS war is deployed in Apache Tomcat. Prerequisites Oracle XE Database JRE_HOME environment variable set to the appropriate JAVA directory SQL*Plus or SQL CLI Apache Tomcat Oracle Apex and ORDS zip downloaded from Oracle downloads Viedo Tutorial https://www.youtube.com/watch?v=57h1uW-E02o
Post a Comment
Read more

Oracle Apex - Email Using AWS Simple Email Service (SES)

Reason for writing this article I had to spend a good amount of time to clear the issue "ORA-29024: Certificate validation failure" after configuring AWS SES SMTP in Oracle Apex. Thought of sharing the steps followed so that it may help someone trying to figure out the same problem.  Background AWS SES is a cloud-based email sending service from Amazon. If you are on the AWS platform, then AWS SES may be a good choice for your Apex application. I found these two well-written blogs that explain the whole process of configuring SMTP in Oracle Apex. http://thinkoracleapex.blogspot.com/2018/12/integrate-your-apex-application-with.html https://icurly.net/2019/07/12/how-to-send-emails-from-apex-to-an-external-source-using-gmails-smtp/ Kudos to the authors. I followed the instructions in their blog except for the process of downloading a root certificate for SES SMTP end-points.  Most of the article gives you an easy method to obtain the certificate by clicking on the padlock icon i...
Post a Comment
Read more

Oracle Apex - Upload Files to Amazon S3 Directly From Browser

This article is about uploading files from Oracle Apex to AWS S3. The files are directly uploaded to S3 without using any intermediate storage. The metadata is written to application DB to simplify further access.  Reference:  https://docs.aws.amazon.com/sdk-for-javascript/v2/developer-guide/s3-example-photo-album.html AWS Tasks Complete the prerequisite tasks described in  https://docs.aws.amazon.com/sdk-for-javascript/v2/developer-guide/s3-example-photo-album.html . This includes setting an S3 bucket, Amazon Cognito Identity Pool, Configuring IAM, and configuring CORS.  You will require bucket name, bucket region and pool id to access S3. Credentials are stored in DB and accessed using apex.server process while the user clicks the upload button. Apex Tasks Step#1  Add AWS SDK in your application user interface details. Refer the attachment. Step#2  Create a PL/SQL dynamic region using below given code htp.p('<div> <input type="file" id="fileUploa...
Post a Comment
Read more

Installing Oracle JDeveloper 12.1.3 - ADF 12C (12.1.3)

Today I'm going to discuss about the installation of Oracle JDeveloper 12.1.3 to develop ADF 12C (12.1.3) compatible applications on a windows machine. This is a quick start guide, please refer Oracle documentation for detail installation instructions. https://docs.oracle.com/middleware/1213/jdev/install/toc.htm Prerequisites Ensure that a certified JDK exists on your system. If not download and install JDK. http://www.oracle.com/technetwork/java/javase/downloads/index.html Step-1 Download JDeveloper Studio from OTN website. http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html Step-2 Navigate to the directory where you have downloaded JDeveloper studio. I've downloaded 64 bit windows installer. Right click on the installer and run the application as administrator.  This will start the installation of JDeveloper. Alternatively you can start installer by navigating to the directory and executing the command from command prompt. jdev_sui...
Post a Comment
Read more

How to unlock sample HR schema in Oracle

Oracle provides a sample HR (Human Resource) schema. Bu default this schema is locked and if you want to use this schema for learning purpose it need to be unlocked first. Follow these steps. Connect to database as system user (SYS AS SYSDBA) with the password provided during installation. Execute the following SQL statement. ALTER USER HR IDENTIFIED BY <password> ACCOUNT UNLOCK; Replace <password> with the password you want to use. You just unlocked HR schema. Connect to HR schema and start learning. Happy learning.
Post a Comment
Read more