Calling a Rest API from Oracle Block

Rajan Sw

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

Mike Kutz

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.

Rajan Sw

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.

Mike Kutz

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.