To send mails in our projects most often we use Oracle Cloud Email Delivery Service. From official OCI Email Delivery description you can find: "Oracle Cloud Infrastructure Email Delivery is an email sending service that provides a fast and reliable managed solution for sending high-volume emails that need to reach your recipients' inbox. Email Delivery provides the tools necessary to send application-generated email for mission-critical communications such as receipts, fraud detection alerts, multi-factor identity verification, and password resets." ... sounds good ? yes and works good as w ..read more

Few days ago I had to develop dynamic query json export module. As a sandbox I prepared PLSQL block: DECLARE c sys_refcursor; l_sql varchar2(4000) := 'select null as "col1", 100 as "col2" from dual union all select 200 as "col1", null as "col2" from dual'; l_file clob;BEGIN open c for l_sql; apex_json.initialize_clob_output; apex_json.open_object; apex_json.write('rowset', c); apex_json.close_object; l_file := apex_json.get_clob_output; apex_json.free_output ..read more

This year I was first time presenter on APEX Connect 2019 in Bonn. First time ever! This was a huge for me. Before this one I did some internal presentations and worked as APEX trainer from time to time, but this was a first one on international conference. The amount of stress was far above my normal limits! :) But. It's all worth it! The venue was great! The organization was great! The people were great! We all know that going to conferences take time and money, but going there will give you more. You can gain some knowledge from presentations. You can talk with others about same probl ..read more

The plugins we release helps you easly upload files to Amazon AWS S3. Below we have simple installation tutorial and for more you can always visit our DEMO application. Actually, this plugin is in 2 parts: - "FMcomponent" part is APEX item. Something like native filebrowser item but fully configurable. You can always customize how it with a sparkle of CSS. - "FMproviders" part serves as connection to one of the file storage service (eg. Amazon S3, Dropbox, etc) To use it, you have to grand DBMS_CRYPTO privilege to your Oracle schema: grant execute on sys.dbms_crypto to <schema> ..read more

While the automatic time zone works, it looks bad. Often when the main page is heavy user needs to look on the white page for a while. APEX doesn't let you change this page natively. I have a nice MIP (Make It Pretty) for you. Check the results: Try our sandbox demo to see the result! Steps to implement the solution: 1) In "Application -> Shared Components -> Application Processes" create a process "On Load: Before Header" with this PL/SQL: declare v_timezone varchar2(4000) := apex_util.get_session_time_zone();begin -- if no timezone then go to error message if( v_timezone is null ..read more

Two-factor authentication means that you must have two factors, to access your account. The first factor is something you know, like your login and password combination. The second is something you have, like a mobile device with a security app installed. That second factor — the mobile device with a security app — adds an extra layer of protection to your account. Even if hackers steal your password, they can’t log in, because they don't have your mobile device. Try 2FA on our SANDBOX environment! It is the most popular 2FA option based on Times-based One-Time Password (TOTP) alghoritm d ..read more

About 10 years ago I tried to build APEX application on MS SQLServer. It was possible but performance was not satisfactory. (You can read this post here)... Today I will describe how to use APEX with MySQL. Obviusly I don't think it is good idea to build APEX app only on MySQL. It can be used as part of Hybryd solution (Oracle + MySQL or Postrgres). My description covers integration with MySQL. As a result will be APEX application with Interactive Report and CRUD form based on MySQL data. Description contains two parts: First part is a MySQL site, Second part is a APEX application part P ..read more

Today there was a need of using simple, dictionary SQL query result as an array in JavaScript. Solution is quite simple - region with PL/SQL Dynamic Content. Here you have a short video with example. Changing Select List causes showing Checkboxes in rows, on which specific action can be processed. Code of PL/SQL region, which creates array: htp.p('<script>');htp.p('var actions = [];');for x in (select ID, STATUS_FROM from ACTIONS)loophtp.p('actions[' || x.id || '] = "' || x.status_from || '";');end loop;htp.p('</script>'); JavaScript code for Dynamic Action, which uses the ..read more

In the last blog post I prepared Oracle side. In this post I will show, how to prepare ALEXA Skill and how to integrate all layers. Few weeks ago Amazon implemented new version of Alexa Skill Kit. Alexa Skill Kit is like a APEX builder. Low code technology, so you don't need to write any code :) Let's start ! Go to Amazon Developer Console 1. Click Get Started on Alexa Skills Kit 2. As you can see on screen below there is already one skill on my list. Click on Create Skill to Create new one. 3. The name of my Skill will be - APEXUTIL Pizza  :) but you can name it as you wish ..read more

I found few examples how to integrate Amazon Alexa with Oracle. All solutions used Amazon Lambda microservice (node.js). But it’s not necessary. You need only two elements: Oracle with ORDS and Amazon Alexa Skill. Prerequsites: - Amazon account (https://developer.amazon.com/ ) - Oracle 11g + - Oracle ORDS (accessed thru SSL) - APEX (optionaly) 1. For demo I used only one simple table: create table alexa_orders ( alo_id raw(16) default sys_guid() primary key, alo_name varchar2(4000), alo_qty number, alo_value number, alo_date date, alo_status varchar2(1024), al ..read more