DEV Community: Rajesh Vohra

[Boost]

Rajesh Vohra — Tue, 02 Dec 2025 20:48:54 +0000

Oracle APEX (Rest Integration Code Snippets)

Rajesh Vohra ・ Dec 2

Oracle APEX (Rest Integration Code Snippets)

Rajesh Vohra — Tue, 02 Dec 2025 20:45:55 +0000

(A) Calling a REST API From APEX Using APEX_WEB_SERVICE
Example: Calling OCI Functions or Any REST Endpoint
DECLARE
l_url VARCHAR2(2000) := 'https://api.example.com/process';
l_body CLOB := '{"id":123, "action":"submit"}';
l_result CLOB;
BEGIN
l_result := APEX_WEB_SERVICE.make_rest_request(
p_url => l_url,
p_http_method => 'POST',
p_body => l_body,
p_wallet_path => 'file:/u01/app/oracle/wallet',
p_wallet_pwd => 'password'
);
-- Log or parse the JSON response
dbms_output.put_line(l_result);
END;
When to use
✔ Calling serverless functions (OCI Functions)
✔ Integrating external APIs
✔ Sending data to microservices
(B) Uploading Files to OCI Object Storage
Useful for APEX apps that handle documents, images, invoices, or uploads.
DECLARE
l_url VARCHAR2(4000) := 'https://objectstorage..oraclecloud.com/n/namespace/b/bucket/o/myfile.pdf';
l_blob BLOB;
BEGIN
SELECT file_blob INTO l_blob
FROM my_docs
WHERE id = :P1_DOC_ID;
APEX_WEB_SERVICE.make_rest_request(
p_url => l_url,
p_http_method => 'PUT',
p_body_blob => l_blob,
p_wallet_path => 'file:/u01/app/oracle/wallet',
p_wallet_pwd => 'password'
);
END;
When to use
✔ Uploading resumes, invoices, PDFs
✔ Storing images, documents, reports
✔ Archiving files securely
Calling OCI AI Language or Vision Service
AI Language Example: Sentiment / Key-Phrases
DECLARE
l_body CLOB := '{
"documents": [
{"text": "The service was excellent!", "id": "1"}
]
}';
l_response CLOB;
BEGIN
l_response := apex_web_service.make_rest_request(
p_url => 'https://.../language/sentiment',
p_http_method => 'POST',
p_body => l_body,
p_wallet_path => 'file:/u01/app/oracle/wallet'
);
:P1_AI_RESULT := l_response;
END;
When to use
✔ Customer feedback analysis
✔ Support ticket prioritization
✔ Chatbot intelligence and routing
(D) Calling a REST-enabled Table or View Using ORDS
If you expose a table through ORDS, APEX can read it like any other REST endpoint.
SELECT *
FROM apex_web_service.g_response_clob;
When to use
✔ Microservice-style data sharing
✔ Integrating multiple APEX apps
✔ Exposing data to partners
Use-Case-Based Recommendations
Here are practical, real-world examples for the most common APEX + OCI integration scenarios.
A. Document Processing Use Cases

Automated PDF Extraction & Classification
Perfec for: HR onboarding, invoices, receipts, forms
OCI Services: Object Storage, AI Document Understanding, Functions
APEX Role: Upload UI + results viewer
Flow:
User uploads document in APEX
Stored in OCI Object Storage
AI Document Understanding extracts entities
APEX displays structured results (date, amount, vendor, etc.)
Image Recognition Inside APEX
Perfect for: Field inspections, asset management
OCI Services: Vision AI
Flow:
Upload photo → send to OCI Vision
Vision returns labels, anomalies
APEX triggers workflow or flags issues
Generate PDFs Automatically
Perfect for: Reports, certificates, receipts
OCI Services: OCI Functions + open-source libraries OR APEX built-in PDF printing
B. Chatbots and Intelligent Assistants
LLM-Powered Chat Assistant Inside APEX
Perfect for: Customer portals, HR helpdesks
OCI Services: OCI Generative AI, OCI Language
APEX Role: Chat UI + history log
Flow:
APEX sends user message to OCI Gen AI
Receive structured response
Store chat history
Display in a chatbot-style UI
Smart Ticket Categorization
Perfect for: IT service desk, municipal complaints
OCI Services: AI Language (sentiment, classification)
Flow:
APEX form → AI Language → auto-assign priority/team
C. Dashboards and Analytics
Real-Time Operational Dashboard
Perfect for: Logistics, finance, retail
OCI Services: Streaming (Kafka-like), API Gateway
Flow:
Data streams into the DB → APEX refreshes dashboard with Live Polling
Executive KPI Dashboards
Perfect for: Management reporting
OCI Services: Oracle Analytics Cloud (optional), ADW
Flow:
APEX consumes curated ADW models → interactive charts, drilldowns
Audit & Security Dashboard
Perfect for: Compliance, security teams
OCI Services: Data Safe, Logging, Monitoring
Flow:
APEX queries Data Safe logs → show risky users, anomalies, audit alerts

[Boost]

Rajesh Vohra — Tue, 18 Nov 2025 06:49:38 +0000

Revolutionizing SQL Development with Oracle APEX AI Assistant

Rajesh Vohra ・ Oct 20

#oracle #cloud #sql #ai

[Boost]

Rajesh Vohra — Tue, 18 Nov 2025 06:41:25 +0000

Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

Rajesh Vohra ・ Nov 18

#javascript #beginners #database #sql

Getting Started with JavaScript in Oracle: Simple MLE Use Cases and Procedures

Rajesh Vohra — Tue, 18 Nov 2025 06:39:30 +0000

Oracle’s Multilingual Engine (MLE) allows you to run JavaScript directly inside the database alongside PL/SQL. This lets you create procedures, functions, and modules in JavaScript that can be called from PL/SQL. MLE is great for beginners because it makes it easy to mix SQL and JavaScript, run small tests quickly, and write reusable logic in a familiar language.

Anonymous Inline JavaScript Procedure

Use Case: Quickly test JavaScript logic without creating a module.

CREATE OR REPLACE PROCEDURE inline_js_demo
AS MLE LANGUAGE JAVASCRIPT PURE
{{
let msg = 'Hello from inline JavaScript!';
console.log(msg);
}};
/

BEGIN
inline_js_demo;
END;
/

What happens:

Quick execution of JS logic.

No module creation needed.

Useful for small computations or testing.

Calculate Sum of Two Numbers (PURE Execution)

Teaches: PURE environment, simple math logic

JavaScript Module
CREATE OR REPLACE MLE MODULE calc_mod
LANGUAGE JAVASCRIPT AS
export function sum(a, b) {
return a + b;
}
/

PURE Environment
CREATE OR REPLACE MLE ENV calc_env
IMPORTS ('calc_mod' MODULE calc_mod) PURE;
/

Procedure
CREATE OR REPLACE FUNCTION js_add(p_a NUMBER, p_b NUMBER)
RETURN NUMBER
AS MLE MODULE calc_mod ENV calc_env
SIGNATURE 'sum(num,num)';
/

Execution
SELECT js_add(10, 25) AS result FROM dual;

Convert text to Uppercase Using JS

Teaches: JS string functions, returning values

Inline JS Function
CREATE OR REPLACE FUNCTION js_upper(p_text VARCHAR2)
RETURN VARCHAR2
AS MLE LANGUAGE JAVASCRIPT
{{
let input = session.getInput('TEXT');
return input.toUpperCase();
}}
;
/

Call It
SELECT js_upper('hello oracle js mle') FROM dual;

Calculate Average Salary from a Table Using JavaScript SQL Driver

Teaches: Executing SQL inside JavaScript (MLE SQL driver)

JavaScript Module
CREATE OR REPLACE MLE MODULE emp_mod
LANGUAGE JAVASCRIPT AS
import * as oracledb from "mle-js-oracledb";

export function avgSalary() {
let conn = oracledb.defaultConnection();
let rs = conn.query(SELECT AVG(salary) avg_sal FROM Employees);
return rs[0].AVG_SAL;
}
/

Procedure + Call Spec
CREATE OR REPLACE FUNCTION js_emp_avg
RETURN NUMBER
AS MLE MODULE emp_mod
SIGNATURE 'avgSalary()';
/

Usage
SELECT js_emp_avg FROM dual;

Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

Rajesh Vohra — Tue, 18 Nov 2025 06:28:34 +0000

The Multilingual Engine (MLE) in Oracle 26ai opens a whole new world for developers by allowing JavaScript to run natively inside the database, right alongside traditional PL/SQL. For beginners, this means you can combine the simplicity of JavaScript with the power of Oracle’s SQL engine to build cleaner logic, faster transformations, and more flexible procedures. The examples below walk through easy, practical use cases—from formatting text and doing basic math to running SQL queries and returning JSON—all designed to help new users quickly understand how PL/SQL and JavaScript work together through MLE.
Here are few simple and easy to understand examples:

1. Dynamic Execution of JavaScript (DBMS_MLE.eval)

Use Case: Print "Hello World" dynamically using JavaScript from PL/SQL.

SET SERVEROUTPUT ON;

DECLARE
l_ctx DBMS_MLE.context_handle_t;
l_jscode CLOB;
BEGIN
-- Create a dynamic execution context
l_ctx := DBMS_MLE.create_context;

-- JavaScript code stored in a CLOB
l_jscode := q'~
    console.log('Hello World, dynamically from JavaScript!');
~';

-- Execute JavaScript dynamically
DBMS_MLE.eval(
    context_handle => l_ctx,
    language_id    => 'JAVASCRIPT',
    source         => l_jscode,
    source_name    => 'DynamicHelloWorld'
);

-- Drop the context to free resources
DBMS_MLE.drop_context(l_ctx);

END;
/

What happens:

A new execution context is created.

JavaScript code is executed dynamically.

Output is printed via DBMS_OUTPUT.

Context is explicitly dropped.

2. Using JavaScript Modules with PL/SQL (MLE Module Calls)

Use Case: Encapsulate reusable logic in a module and call it from PL/SQL.

Step 1: Create a JavaScript Module
CREATE OR REPLACE MLE MODULE hello_module
LANGUAGE JAVASCRIPT AS
function sayHello(name) {
console.log(Hello, ${name} from JS module!);
}
export { sayHello };
/

Step 2: Create a PL/SQL Procedure Call Specification
CREATE OR REPLACE PROCEDURE hello_proc(p_name VARCHAR2)
AS MLE MODULE hello_module
SIGNATURE 'sayHello(text)';
/

Step 3: Call the Procedure in PL/SQL
BEGIN
hello_proc('Alice');
END;
/

What happens:

hello_module stores reusable JS code.

hello_proc exposes JS function to PL/SQL.

Output is printed via DBMS_OUTPUT.

3. PURE Execution for Secure JavaScript

Use Case: Run computational code without accessing database state.

Step 1: Create a PURE JavaScript Module
CREATE OR REPLACE MLE MODULE pure_module
LANGUAGE JAVASCRIPT AS
export function addNumbers(a, b) {
console.log(Sum is: ${a + b});
}
/

Step 2: Create a PURE Environment
CREATE OR REPLACE MLE ENV pure_env
IMPORTS('pure_module' MODULE pure_module) PURE;
/

Step 3: Create a Call Specification Using PURE Environment
CREATE OR REPLACE PROCEDURE add_numbers_proc(p_a NUMBER, p_b NUMBER)
AS MLE MODULE pure_module ENV pure_env
SIGNATURE 'addNumbers(num,num)';
/

Step 4: Execute the Procedure
BEGIN
add_numbers_proc(10, 20);
END;
/

What happens:

Code runs isolated from database objects.

Ideal for running third-party libraries or computations securely.

Only allows input/output operations.

[Boost]

Rajesh Vohra — Sat, 25 Oct 2025 04:50:37 +0000

New on Oracle Dev Gym: Groovy Basics and Advanced Fundamentals

Rajesh Vohra ・ Oct 25

New on Oracle Dev Gym: Groovy Basics and Advanced Fundamentals

Rajesh Vohra — Sat, 25 Oct 2025 04:20:29 +0000

The Oracle Dev Gym just got even more exciting! I’ve introduced a brand-new category dedicated to Groovy Basics and Advanced Fundamentals, giving developers a fun and interactive way to strengthen their Groovy skills.
At the Oracle Dev Gym, learning is an active experience — much like a workout at a real gym. After all, you can’t get stronger just by watching someone lift weights! The same applies to coding. Dev Gym workouts keep your knowledge fresh and your thinking sharp.
Here’s how it works:
• Take individual quizzes — multiple-choice questions designed to test and deepen your understanding.
• Step it up with workouts — combine articles or videos with follow-up quizzes that reinforce what you’ve learned.
• Train with over 2,400 quizzes — covering SQL, PL/SQL, Database Design, Java, and now, Groovy!
• Explore mini-MOOCs — short, focused courses that help you master new skills quickly.
The new Groovy section offers both basics, intermediate and advanced fundamentals, perfect for developers looking to explore this dynamic language or sharpen their existing skills.
Start your Groovy learning workout today:
https://devgym.oracle.com/pls/apex/f?p=10001:SEARCH:113418077756753::::P1202_SEARCH:Groovy
At the Oracle Dev Gym, you build coding strength through exercise — so grab your virtual dumbbells and start your Groovy workout today!

[Boost]

Rajesh Vohra — Mon, 20 Oct 2025 00:10:22 +0000

Revolutionizing SQL Development with Oracle APEX AI Assistant

Rajesh Vohra ・ Oct 20

#oracle #cloud #sql #ai

Revolutionizing SQL Development with Oracle APEX AI Assistant

Rajesh Vohra — Mon, 20 Oct 2025 00:09:47 +0000

Oracle APEX 24.1 introduces the APEX AI Assistant, a transformative tool that enables developers to generate SQL queries using natural language prompts. This integration simplifies the development process, making it accessible to developers of all skill levels.

How It Works

The APEX AI Assistant utilizes Oracle Cloud Infrastructure’s Generative AI to interpret natural language inputs and convert them into syntactically accurate SQL queries. It understands table relationships and can generate complex queries involving multiple tables.

Example Workflow:

Input Prompt: A developer types a natural language query, such as “Show total sales per region for the last quarter.”
AI Processing: The assistant processes the input, identifies relevant tables and relationships, and generates the corresponding SQL query.
Iterative Refinement: If the initial query isn’t precise, developers can provide further instructions to refine the output.
Beyond SQL: Comprehensive Code Assistance

The APEX AI Assistant extends its capabilities beyond SQL generation:

Code Explanation: It can explain SQL or PL/SQL code, aiding developers in understanding complex logic.
Code Improvement: The assistant suggests optimizations for performance and readability.
Error Analysis: It analyzes and fixes errors, acting as a personal SQL mentor.
This integrated support enhances productivity and ensures higher accuracy in code generation and maintenance.

Getting Started

To begin using the APEX AI Assistant:

Set Up Oracle Cloud Account: Ensure you have an Oracle Cloud account.
Configure AI Provider: Set up an AI provider, such as OpenAI or Cohere, within your Oracle Cloud Infrastructure.
Integrate with APEX: Follow the Oracle documentation to integrate the AI provider with your APEX workspace.
Once configured, you can start interacting with the AI Assistant directly within the APEX App Builder.

Benefits for Developers

Enhanced Productivity: Streamlines the development process by automating SQL query generation.
Accessibility: Makes SQL development accessible to developers without deep SQL expertise.
Learning Aid: Acts as a tutor, helping developers understand and improve their code.
Error Reduction: Minimizes errors through intelligent code analysis and suggestions.
The APEX AI Assistant in Oracle APEX 24.1 is a game-changer for developers, simplifying SQL development and enhancing productivity. By integrating natural language processing with database interactions, it empowers developers to build robust applications more efficiently.

DEV Community: Rajesh Vohra

[Boost]

Oracle APEX (Rest Integration Code Snippets)

Rajesh Vohra ・ Dec 2

Oracle APEX (Rest Integration Code Snippets)

[Boost]

Revolutionizing SQL Development with Oracle APEX AI Assistant

Rajesh Vohra ・ Oct 20

[Boost]

Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

Rajesh Vohra ・ Nov 18

Getting Started with JavaScript in Oracle: Simple MLE Use Cases and Procedures

Anonymous Inline JavaScript Procedure

Calculate Sum of Two Numbers (PURE Execution)

Convert text to Uppercase Using JS

Calculate Average Salary from a Table Using JavaScript SQL Driver

Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

1. Dynamic Execution of JavaScript (DBMS_MLE.eval)

2. Using JavaScript Modules with PL/SQL (MLE Module Calls)

3. PURE Execution for Secure JavaScript

[Boost]

New on Oracle Dev Gym: Groovy Basics and Advanced Fundamentals

Rajesh Vohra ・ Oct 25

New on Oracle Dev Gym: Groovy Basics and Advanced Fundamentals

[Boost]

Revolutionizing SQL Development with Oracle APEX AI Assistant

Rajesh Vohra ・ Oct 20

Revolutionizing SQL Development with Oracle APEX AI Assistant

Oracle VBCS - Alta theme is obsolete

Upgrading Oracle VBCS Apps: Moving from Alta to the Modern Redwood Theme

Rajesh Vohra ・ Aug 24

Ai Agent in Oracle Fusion Cloud

Oracle Fusion Cloud – 25D AI Agent Studio Executive Summary

Rajesh Vohra ・ Oct 14