ORDS Create Basic Authentication for a RESTful Web Service

ORDS Basic Authentication 1. To protect the web service, we need to create a role with an associated privilege, then map the privilege to the web service BEGIN ORDS.create_role( p_role_name => 'boomi_role' ); COMMIT; END; / -- Display the role. COLUMN name FORMAT A20 SELECT id, name FROM user_ords_roles WHERE name = 'boomi_role'; ID NAME … Continue reading ORDS Create Basic Authentication for a RESTful Web Service

ORDS 18.2 – The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named

ORDS Version : 18.2 Oracle Version : 12cR2 Error : The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named HR Desc: The error occurs when you have published a RESTful web service from a table inside a schema. When you try to call the Webs service … Continue reading ORDS 18.2 – The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named

Add Image to Column from URL Column Value Apex

Create a new interactive report based on SQL Query. Make sure the column where image is store is populated in the column 'PHOTO' of the table Go to Columns > Column Formatting and add to HTML Expression below code <img src="#PHOTO#" alt="Image Not Found" height="200" width="260"> - 'PHOTO' is the name of the column which … Continue reading Add Image to Column from URL Column Value Apex

Upgrade Oracle Apex from 5.1.x to 18.1

Oracle has released the latest version of Apex and keeping in line with their naming convention Apex has jumped from version 5.1.4 to 18.1 . The new version of Apex has many exciting new features, you can read about them all here Setup : Apex Version : Oracle Apex 5.1.4 Webserver : ORDS Running on … Continue reading Upgrade Oracle Apex from 5.1.x to 18.1

Quick and Easy Integration with Twitter with Apex 18.1

Quick Integration with Twitter in Oracle Apex 18.1 https://blogs.oracle.com/apex/quick-and-easy-twitter-api-with-apex-181