Oracle

This category is meant to be used for blogging about Oracle technologies

Don’t Panic, It’s Just Your Wallet in APEX

Working with blockchain data in traditional enterprise environments can feel a bit like trying to mix oil and water. Between smart contracts, RPC nodes, ABI files, and all the other moving parts, it’s easy to get lost—especially when your main focus is building applications with Oracle APEX. In our previous article, we tackled this challenge [...]

2025-05-09T10:22:24+02:00May 9th, 2025|AI, APEX, Blockchain, blog, Oracle|0 Comments

Novocoin with Oracle Blockchain: Who Needs a Lambo ?

Oracle Blockchain Platform is a preassembled PaaS solution that enables businesses to quickly deploy and manage blockchain networks. It includes all necessary components such as compute, storage, containers, identity services, and event management, along with an intuitive console for easy administration. Built on Hyperledger Fabric, Oracle enhances this open-source framework with automated provisioning, multi-cloud and [...]

2025-05-05T16:30:48+02:00May 6th, 2025|APEX, Blockchain, blog, Oracle|0 Comments

Oracle APEX and OpenAI Walk Into a Bar… And Build an Assistant – Part 2

Building on our previous discussion about integrating OpenAI Assistants with Oracle APEX, this article focuses on structuring and displaying user interactions efficiently. Instead of frequent database queries, APEX collections provide session-based storage for optimized performance. The PR_LOAD_MESSAGES procedure initializes the conversation by retrieving system messages, structuring collections, and handling errors. Messages are displayed dynamically using [...]

2025-04-22T11:24:13+02:00April 24th, 2025|AI, APEX, blog, Oracle|0 Comments

Oracle APEX and OpenAI Walk Into a Bar… And Build an Assistant – Part 1

Previously, we explored the OpenAI API's completion models, which enabled text generation and language-based automation. Now, we are shifting our focus to OpenAI's new Assistant API, a more structured approach that enhances interactions by integrating memory, function calling, and multi-step reasoning. This new paradigm allows for more sophisticated and context-aware AI-driven assistants that can work [...]

2025-04-22T11:23:51+02:00April 22nd, 2025|AI, APEX, blog, Oracle|0 Comments

Oracle APEX Collections: Efficiently Managing Temporary Data

Introduction In Oracle APEX, there are situations where we need to manage temporary data before deciding whether to store it permanently. APEX Collections provides an efficient way to handle this by offering an in-memory storage mechanism that remains active throughout a user's session. Rather than immediately writing data to a database table, collections allow us [...]

2025-04-08T11:04:21+02:00April 8th, 2025|APEX, blog, Collections, Oracle|0 Comments

How to Prevent SQL Injection Attacks in APEX (Beyond the Basics)

SQL injection remains one of the most exploited vulnerabilities in web applications, and Oracle APEX is no exception. Despite APEX’s built-in protections, poor use of dynamic PL/SQL and configuration mistakes can expose your application to attacks. In this article, we explore advanced techniques to prevent SQL injection attacks in APEX, going beyond basic measures like [...]

2025-03-31T17:03:25+02:00April 1st, 2025|APEX, blog, Oracle|0 Comments

Building an Oracle APEX Plugin: A Deep Dive, part 3

Now we need to move on to the JavaScript portion, which forms the core of our proposal: replacing the item's default validation with a fully customized solution tailored to our specific requirements. This step is crucial, as it allows us to override Oracle APEX’s standard validation behavior and implement logic that aligns with the unique [...]

2025-03-24T12:10:47+01:00March 25th, 2025|APEX, blog, Oracle|0 Comments

Building an Oracle APEX Plugin: A Deep Dive, part 2

In our previous article, we briefly introduced custom attributes, but you might be wondering—what exactly are they and why do they matter? Custom attributes in Oracle APEX plugins are user-defined settings that empower developers to significantly extend and customize a plugin's behavior, appearance, and functionality. Defined explicitly when creating the plugin, these attributes become part [...]

2025-03-24T12:11:06+01:00March 19th, 2025|APEX, blog, Oracle|0 Comments

Building an Oracle APEX Plugin: A Deep Dive, part 1

Oracle APEX plugins are a powerful way to extend the platform’s functionality, allowing developers to create custom behaviors, components, and validations tailored to specific needs. In this post, we’ll guide you step by step through the process of building an Oracle APEX plugin. By the end, you’ll have a strong foundation for creating dynamic, reusable [...]

2025-03-24T12:11:32+01:00March 17th, 2025|APEX, blog, Oracle|0 Comments

JS Manipulations for APEX regions (Interactive Grid)

Introduction Oracle APEX provides built-in dynamic actions that allow developers to perform basic interactions without writing custom JavaScript. These actions can be triggered by events such as clicking a button, changing the value of a field, or selecting an option from a dropdown. While these built-in features cover many everyday use cases, more complex interactions [...]

2025-03-11T08:50:38+01:00March 11th, 2025|APEX, blog, JavaScript, Oracle|0 Comments
Go to Top