Posts

Oracle APEX Developers Are Saying Goodbye to the Old RESTful Services

-
Image
  Imagine you're deep in your Oracle APEX workspace, happily clicking away in SQL Workshop to tweak a REST API endpoint. Suddenly, a big red DEPRECATED banner stares back at you like an old friend who's overstayed their welcome !!! If you're still building or maintaining RESTful Services directly inside APEX's SQL Workshop, you're not alone ,but Oracle made it clear starting with ORDS 25.1: the classic RESTful Services interface in APEX is officially deprecated😐 SQL Developer Web 👀 , that's now the single source of truth for managing ORDS REST APIs. 👉 Creating the RESTful Service in SQL Developer  Web STEP1: STEP2: In SQL Developer Web, navigate to the "REST" .it is in hamburger menu and you can find it in below picture now you are here .look at below picture isn't familiar with you? we have all RESTFUL Service features now at the top of the page STEP3: let's create a restful webservice. Click on Module in the top menu and fill the propert...
Post a Comment
Read more

Secure RESTful Web Service in Oracle APEX with Basic Authentication

-
Image
Heard they say you should secure your web service? 👮   Stick with me in this article, and I’ll show you a professional way to secure your RESTful Web Service with Basic Authentication   In the previous article, I explained how to CREATE  a RESTful Web Services inside Oracle APEX. https://lidagholizadeh.blogspot.com/2025/08/all-about-restful-webservice-in-oracle.html In this Article I will shows you how to build a professional, secure JSON RESTful web service in Oracle APEX that returns employee details from the HR.EMPLOYEES table, protected by Basic Authentication with PBKDF2 password hashing. Prerequisites Oracle Database 19c or later Oracle APEX 21.1 or newer HR sample schema unlocked and available EXECUTE on DBMS_CRYPTO A workspace with privileges to create RESTful Services 🚴 Let's GO Step 1 – Create a Table to Store Web Service Users CREATE TABLE ws_users ( username VARCHAR2 ( 100 ) PRIMARY KEY, password_hash VARCHAR2 ( 64 ) NOT NULL , -- ...
2 comments
Read more

USING External REST API in Oracle APEX

-
Image
  In the previous article, I explained how to CREATE  a RESTful Web Services inside Oracle APEX. https://lidagholizadeh.blogspot.com/2025/08/all-about-restful-webservice-in-oracle.html In this article, we will focus on the opposite scenario: How to consume external REST APIs from Oracle APEX and PL/SQL. External API integration is one of the most common requirements in APEX applications. In this article I will explain all supported methods for calling external REST APIs in Oracle APEX: 1.  Calling REST APIs Using Web Source Modules 2.  Calling REST APIs  from PL/SQL Using APEX_WEB_SERVICE 3. Use Rest Data Sources in Our Application But first of all let me answer this question ❓ Where Can You Use Your Newly Created Web Source Module in Oracle APEX ❓ The short answer: Almost everywhere in APEX💖 As soon as you see the Source → Type property on a component and one of these options appears, you can directly plug in your external REST API (Web Source): Interactive...
Post a Comment
Read more

BUILDING a RESTful Web Services in Oracle APEX

-
Image
❓What is a Web Service? A web service is a mechanism for sending and receiving data between two different systems over a network, commonly using HTTP. There are two main kinds of web services: RESTful : A lightweight, fast architectural style using HTTP verbs such as GET, POST, PUT, DELETE, typically exchanging JSON  or XML SOAP : An older and more formal standard-based web-service architecture, built on XML and often more complex in setup. *Tip: In the context of Oracle APEX we typically work with RESTful web services. ❓ API or REST Web Service? In everyday conversation, people sometimes use the terms API and REST web service interchangeably, but technically,  every REST Web Service is an API,but  not every API is REST Web Service. For example, a SOAP API or gRPC service uses a different architecture and may not revolve around HTTP or resources. they are not the same : API (Application Programming Interface) : A broad concept referring to a set of rule...
Post a Comment
Read more