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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
Oracle APEX is an incredibly powerful platform for building web applications, and one of its standout features is the ability to create custom plugins. This post explores an introductory example of implementing custom validation logic for text fields using an Oracle APEX plugin, combining both server-side and client-side logic to deliver flexibility and a seamless [...]
Artificial Intelligence (AI) is transforming how applications interact with users by providing dynamic and intelligent responses. Oracle APEX, with its low-code development environment, enables seamless integration of AI-powered services through REST Data Sources. By leveraging APEX_EXEC, we can call AI APIs, process responses, and display them in real-time within an APEX application. Continuing with our [...]
Now that we have covered everything related to document management in our previous articles, the next step is to implement the file download functionality, allowing users to retrieve and view the files stored in our repository. Additionally, it is important to note that for files of type "assistant and messages", we need to block the [...]
