Forum Stats

  • 3,828,128 Users
  • 2,260,865 Discussions


Calling a Rest API from Oracle Block

Rajan Sw
Rajan Sw Member Posts: 354 Blue Ribbon
edited May 20, 2022 1:32PM in SQL & PL/SQL

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 !!!