SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling a Rest API from Oracle Block

Rajan SwMay 19 2022 — edited May 20 2022

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

Added on May 19 2022

#dba, #plsql

3 comments

138 views