Oracle Integration Cloud comes with a library of adapters for both Oracle and 3rd Party applications. All of these capabilities mean that it’s possible to integrate applications faster and increase business agility. I've been writing a lot lately on the topic of Oracle Autonomous Database and also presenting about Oracle Integration Cloud, so I thought, why not merge the 2 subjects and document here how you might go about using the Oracle Integration out-of-the-box adapters to integrate to an Oracle Autonomous Transaction Processing (ATP) or Autonomous Data Warehouse (ADW) instance (both Oracle Autonomous Database - ADB - offerings). In this post I will describe how to use the Oracle Autonomous Database adapter in Oracle Integration Cloud to directly connect to an ATP or ADW instance.
Oracle Autonomous Database: Load Data from a Local File
In this post we will look at the data load from local file feature of "database actions" including how to access this feature and how to use it! This data loading feature is really simple to use allowing you to efficiently create tables or update existing tables with data that you might have stored locally or in the cloud, all without writing any code.
Oracle Autonomous Database: Accessing & Using Database Actions
Database actions can be accessed for Oracle Autonomous Database. In this post we will look at what Database Actions are, how to access/use them and also how to grant access to other users to make the most out of the features available.
Connecting to an ATP Database in Oracle Cloud
In this post, I document the steps to help you to connect to (and use!) a newly created Oracle ATP Database Service
Creating an ATP Database in Oracle Cloud
In this post, I document the steps to help you create your own Oracle ATP Database Service.
Oracle PL/SQL: GROUP BY
I recently wrote, HERE, how I regularly see commonly asked questions appearing in forums relating to the same topic. Like with SELECT INTO from my previous posts, I also see lots of questions about the correct usage of the GROUP BY clause and so I figured that I would write up an explanation of how to properly use this and then, again, I can reference this post's URL in response to questions on this topic!
ORACLE PL/SQL: SELECT INTO Common Errors
In my previous post, I explained how to correctly use the Oracle PLSQL SELECT INTO statement. Here, I will expand on that further by describing common error messages you may see when using SELECT INTO, what you should do about them and most importantly, how you should prepare to handle them in your PLSQL logic.
Oracle PL/SQL: SELECT INTO
Like many in the Oracle community, I occasionally find myself looking through forums and helping out where I can. I consistently see some basic questions cropping up in forums like StackOverflow, often the same question over and over again - one of which is regarding the "SELECT INTO" statement. I have found myself writing responses to questions about SELECT INTO statements many times and so I figured that I would write up an explanation of how to properly use this and then I can reference this post's URL in response to questions on this topic! Side note: It's been quite some time that I used PL/SQL and really enjoyed spinning up an oracle database in my free tier account and writing this post - perhaps expect a few more similar style posts alongside my usual content (maybe more commonly asked forum topics)
Oracle CloudWorld 2022
In this post, I share some thoughts, observations and memories from Oracle Cloud World 2022.
Oracle JET – Getting Started