Home
Feed

Extend

Hashnode Pro
Hashnode for Agents

Resources

The foreword
Hashnode gql skill

Buildful - AI coding agent that delivers frontier-level results at a fraction of the cost Bug0 - The AI-native e2e QA regression testing Hackathons Changelog Brand @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap

Search Hashnode

Search posts, tags, users, and pages

Discussion on "JSON Parsing in Oracle SQL and PL/SQL" | Hashnode

Feed/

Discussion

Jon Dixon

APEX, ORDS & the Oracle Database

Sep 5, 2022

JSON Parsing in Oracle SQL and PL/SQL

As an Oracle APEX developer, I regularly consume JSON from external web services. When I can, I use APEX REST Data Sources or the APEX_DATA_PARSER PL/SQL API to turn JSON into rows of data that can be easily consumed by APEX. There are many occasions...

blog.cloudnueva.com3 min read

#orclapex #oracle #json

Responses2

Markdown supported · ⌘↵ to post

Enock Oloo

Sep 28, 2023

Hi, this is great but whats the best way to fetch the URL with data end point and insert into Oracle table? do you think i need to set ACL? Oracle 12g.

thanks.

Hi. You will need an ACL, and if you are calling a HTTPS endpoint, you will also need to install the SSL Certificate in your database wallet. If you have APEX installed, then the apex_web_service API is the best way to call web services.

Jon Dixon

APEX, ORDS & the Oracle Database

Sep 28, 2023

Enock Oloo

Sep 29, 2023

Jon Dixon I am using Apex 5.x + Oracle 12g. But my remote json data is accessed via https so i am using using username&password to get the token. that bearer Token i used to pass as part of the parameter to reference the external URL...regards

Jon Dixon

APEX, ORDS & the Oracle Database

Sep 29, 2023

When I call web services from APEX, I do it from the backend using the apex_web_service PL/SQL API. When using apex_web_service, you must have an appropriate ACL, install the TLS certificate in a database wallet and tell APEX where the wallet is from the INTERNAL workspace.

Jon Trøstheim

Mostly focused on contract management, project management, APEX, ORDS, OCI, and the Oracle Database.

Sep 8, 2022

Super nice :-) thanks again Jon

Jon Dixon

APEX, ORDS & the Oracle Database

Sep 8, 2022

No problem, glad you like it.