Restful API using ORDS
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…
Consuming ORDS Rest APIs using PL/SQL
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 Copy CodeCopiedUse a different BrowserDeclare l_clob CLOB; BEGIN l_clob :=…
Posted inAPEX
Clob to Blob Using APEX Web Service
CLOBBASE642BLOB Function This function is used to convert Clob to base64Blob. Syntax APEX_WEB_SERVICE.CLOBBASE642BLOB ( p_clob IN CLOB) RETURN BLOB; Example declare l_clob CLOB; l_blob BLOB; l_blob_2 BLOB; begin SELECT BLOB_CONTENT…
Posted inAPEX
Use of $s $x $v
$x $x is used to find the control on the DOM meaning looking for any item available on DOM. If the control is found then it returns the dom of the…
Posted inORACLE
Blob to Clob Using DBMS_LOB
Create function to convert the blob content to clob Copy CodeCopiedUse a different BrowserCREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) RETURN CLOB AS l_chunk VARCHAR2 (32767); l_position PLS_INTEGER :=…
Posted inORACLE
ORA-06533: Subscript beyond count
ORA-06533: Subscript beyond count Cause: An in-limit subscript was greater than the count of a varray or too large for a nested table. Action: Check the program logic and explicitly…
Posted inAPEX
How to change an item’s LABEL and Placeholder dynamically using a Dynamic Action
How to change an item’s LABEL and Placeholder dynamically using a Dynamic Action To change ITEM labels and placeholders we can try some JavaScript way to do so. Look around…
Posted inAPEX
Generating JSON using APEX_JSON
Generating JSON using APEX_JSON Sample tables from Oracle Create Two table based on below query and Inserted some record for demo purpose: Copy CodeCopiedUse a different BrowserCREATE TABLE DEPT (…
Posted inAPEX
APEX_JSON Nested parsing
APEX_JSON Nested JSON data parsing Sample JSON Copy CodeCopiedUse a different Browser{ "RAW": { "LEVEL_1": "2", "LEVEL_1_ARRAY": [{ "LEVEL_2": { "LEVEL_2_A": "Ashish", "LEVEL_2_ARRAY": [{ "LEVEL_3_A": "00", "LEVEL_3_B": "ABC" }, {…
ORA-06531: Reference to uninitialized collection PLSQL
ORA-06531: Reference to uninitialized collection Error Description:Reference to uninitialized collection Error Cause:An element or member function of a nested table or varray was referenced (where an initialized collection is needed) without…