Skip to main content

Posts

Showing posts from March, 2023

How to display image without page item reference in Oracle APEX

In this section, we'll learn how to display images in our Oracle APEX application without relying on a page item. This method is perfect for situations where we need to show an image directly from a database table column, a file, or a URL without first loading it into a specific page item. We'll cover how to achieve this using a dynamic action and a PL/SQL procedure, making our application more efficient and flexible. By the end of this tutorial, we'll be able to display images dynamically, improving the user experience and reducing page load times. This technique is useful for reports, dashboards, and custom user interfaces where a static page item isn't the best solution. You can vind a visual  solution  from here. STEP 1: Create a blank page. STEP 2: Create a region and set it properties like-          Name:                    Emp          Type:      ...

How to login your Oracle Apex application from cookies

Managing user authentication efficiently is one of the key aspects of building secure and user-friendly web applications. In Oracle APEX, we usually rely on session-based authentication methods such as database accounts, Single Sign-On (SSO), or custom authentication schemes. However, in some cases, you might want to provide a smoother login experience by leveraging browser cookies. This approach allows your application to remember returning users and automatically log them in without repeatedly prompting for credentials. In this post, we’ll explore how to implement cookie-based login in Oracle APEX step by step. For better understanding you can follow login from cookies.   Step- 1: Open your Login Page in Developer mode.  Step- 2: Create a new item and set the below properties-               Name: P9999_REMEMBER               Type: Checkbox Group            ...