Know Low-Code

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

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

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