Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 240 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187.1K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 443 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Calling a Rest API from Oracle Block

Hi Experts,
I asked this question before and did not get definite approach.
I have a table called Account_Details where the account is having raw ( like 12345) values and the system, calling the table will share the masked account nos('abx53defc9867fd'), so before querying the Database there is a requirement to convert the masked the account no to raw account no and pass in the predicate.
For masking and unmasking, it is decided to call an API from the PLSql procedure.
Just wondering anybody has implemented rest API call from PLsql procedure, please provide any thoughts or references .
I am using oracle 12c R2
Thanks in advance !!!
Answers
-
DIY encryption?
Why not just encrypt the column/table/tablespace and let the database do the "mask/unmask" for you?
Oh
APEX_WEB_SERVICES
does REST calls. -
Thanks Mike for the response.
Unfortunately the design is not like this, we are solving the problem as per the design.
Any other resources or references apart from Apex would be highly appreciated.
-
Any other resources or references apart from Apex would be highly appreciated.
UTL_HTTP
Make sure you've added the correct Network ACL. Method to do this is DB version dependant.