Feed
Pro
Search

Author

Write
Drafts

Bug0 - The AI-native e2e QA regression testing Passmark - The open-source AI framework for regression testing Hackathons Changelog Brand Hashnode gql skill - let your AI agent publish to your Hashnode blog The Foreword by Hashnode - official blog from the Hashnode team @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap
Sign in

Search Hashnode

Search posts, tags, users, and pages

FeedDiscussion

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

Responses(2)

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.

Jon Dixon

APEX, ORDS & the Oracle Database

Sep 28, 2023

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.

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.