Hi,
I need to call some APIs from a 3rd party and the recommended authentication method is using JWT.
To enable this, we have been given an encrypted private key and a passcode but I am having trouble decrypting this.
I have attempted to use DBMS_CRYPTO.DECRYPT without success. We have been advised by the 3rd party that the key is encrypted using SHA-512. Based on the docs for DBMS_CRYPTO I can't see a way of doing this using the SHA-512 algorithm. There is an example in the docs for running the decrypt function which I've tried but I think I need a certain combination in the encryption type to get this working. Everything I've tried so far just gives me an ORA-28817 error.
Has anybody had any experience of this and got it working? Is it even possible to decrypt in this way in PL/SQL? For info, our DB is on ATP (shared), v19.
Thanks,
Chris