Oracle Apex | The Blog Pros

December 7, 2021

How to Integrate Google Workspace With Oracle APEX and Oracle Database: Part 2

In the first part of the article, I introduced Google Workspace and Google APIs and told you a little bit about them. I've also shown you how to properly configure the Google API console. Now, let's talk about the main thing: integrating Google Workspace with Oracle Database and an application created in Oracle Application Express. There are two ways you can do that.

Method #1: Integration With Oracle Database and APEX Application Using Google API Client Library for JavaScript

We can start the configuration of the Oracle Database and APEX application. At this point, we created a Google API project with configured consent screen, and Google Drive API enabled. Now, we will add an entry to the ACL access list with the address to Google API. Then we will create an Oracle Wallet, where we will put the certificate responsible for communication with Google API via HTTPS. I will also mention — as a side note — a crucial detail that should be remembered when creating a wallet.

December 7, 2021

How to Integrate Google Workspace With Oracle APEX and Oracle Database: Part 1

Many organizations base their functioning on tools from the Google Workspace package, formerly known as Google Suite. The wide range of useful tools encourages utilizing Google Workspace in every area of the company’s operations. So a key question arises — can Oracle APEX be integrated with Google Workspace in my company? Yes, of course! Recently, I have faced a challenge of this kind. The project was dedicated to pharmacy and one of the functionalities assumed fetching data from Google Sheets and downloading files from Google Drive.

In this extensive step-by-step tutorial, I will show you how to integrate Google Workspace with your Oracle Database and Oracle APEX applications. The tutorial consists of two parts, and each of them is divided into several sections.

April 9, 2019

APEX_COLLECTION: APEX’s Super Power!

Apex Collections (APEX_COLLECTION) is a package that comes with Oracle Apex and is one of the most important features that comes with Oracle APEX. It can be used in many ways for different purposes, but in general, you can think of Apex Collection as a temporary space to store complex data Types — non-scalar — for instance, full row of data from a table or a view (When you work with Apex Temporary table is not a real option). This data can be manipulated in any way and then stored in Table(s). Each Apex Collection can can has 50 varchar2 attributes (c001 -> c0050), 5 number Attributes (n001->n005), 5 date attributes (d001->d005), 1 CLOB attribute (clob001), and 1 BLOB Attribute (blob001). Each member has a sequence number and each collection must have a unique name.

In this tutorial, I will build a collection from the data stored in a table, add more rows from the table to the existing collection, and then I will show you how to add new member to the collection, how to edit a Member, how to delete a member, and how to save the collection back to the table. I will use some simple Dynamic SQL, and we will use dynamic actions too (many of them actually!).