APEX_LANG APEX_LANG.MESSAGE API is great fit for translating messages in APEX. Here we can define a message for each desired language like en, fr etc. MESSAGE function is very usefull to translate the messages or string returned from PL/SQL stored procedures, functions, triggers, packaged procedures, and functions. …

How to get Images from ORACLE REST Web Service ? Oracle REST APIs provides the feature of media resource, here we can write the query with two columns content type and image blob. While i was trying to implement i saw tweaks, the query has to be in below format only. SELECT 'content_type', column FROM . . …

Consuming ORDS Rest APIs using PL/SQL API End point : https://apex.oracle.com/pls/apex/ashish_portfolio/hr/test_emp Parameters : deptno, empno Method : GET Without parameters Declare l_clob CLOB; BEGIN l_clob := APEX_WEB_SERVICE.make_rest_request( p_url => …

Creating Rest API using ORDS ORDS APIs follows the Module, Template, Method. Now let see the Hierarchy of these. Module is top level container, it can contain set of templates . Template is at second level container can contain multiple Handlers. Handler is logical area where the purpose needs to define or what are …