Vikas Pandey, Author at Ontoor blogs

Using APEX Collections Safely: Avoiding Session State Leaks

Oracle APEX Collections are session-scoped data containers designed to hold temporary data during an active user session. They are simple to use, powerful in capability, and fully managed by the…

Vikas Pandey January 10, 2026

APEX Interactive Grid

Customise Column Tooltips in Oracle APEX Interactive Grids Using JavaScript

Oracle APEX offers powerful options to enrich the user experience, and JavaScript plays a key role in extending what is available out of the box. One practical enhancement is adding…

Vikas Pandey January 5, 2026

APEX

Designing an Enterprise Workflow Architecture in Oracle APEX

1. Introduction Oracle APEX provides a strong foundation for building enterprise-grade workflow systems with speed and control. As a low-code platform tightly integrated with the Oracle Database, APEX enables developers…

Vikas Pandey January 4, 2026

APEX APEX Tutorials

How to Create Page Items Dynamically in Oracle APEX

Dynamic item creation in Oracle APEX can greatly enhance application flexibility, allowing you to programmatically add items to regions based on specific requirements. This blog explains the functionality and implementation…

Vikas Pandey January 2, 2026

APEX APEX_WEB_SERVICE API

Building and Consuming REST APIs in Oracle APEX

In today’s software world, APIs (Application Programming Interfaces) are the foundation of integration. Whether your Oracle APEX application needs to connect with mobile apps, third-party platforms, or internal systems, APIs…

Vikas Pandey August 23, 2025

APEX APEX_AUTOMATION

State Management for Multi-Step Forms in Oracle APEX Using Collections

When building enterprise-level applications in Oracle APEX, multi-step forms—also known as wizards—are often necessary for onboarding processes, surveys, dynamic form generation, or multi-part configurations. However, managing form data across these…

Vikas Pandey August 2, 2025

APEX APEX_AUTOMATION

Oracle APEX Automation Architecture – A Complete Guide

Automation is a powerful capability in Oracle APEX that allows you to run background logic on a scheduled basis or based on events such as inserts, updates, or deletes. With…

Vikas Pandey July 26, 2025

APEX

Designing a Robust File Upload Architecture in Oracle APEX

In the modern enterprise landscape, file handling is not a nice-to-have — it’s a core expectation. Whether users are uploading contracts, invoices, reports, or profile images, your Oracle APEX application…

Vikas Pandey July 20, 2025

APEX Interactive Grid JavaScript

Stop Blank Records: Validating Interactive Grid Data in Oracle APEX

Oracle APEX Interactive Grids (IGs) are great for managing multiple rows of data, but they also come with risks.One common issue? Users accidentally submitting incomplete rows. For example, leaving both…

Vikas Pandey July 18, 2025

Interactive Grid

Process Selected Records IG oracle Apex

This blog will guide you through efficiently managing selected records from an Oracle APEX Interactive Grid. We’ll focus on capturing these selected records and inserting them into APEX collections. APEX…

Vikas Pandey March 1, 2025