BCrypt algorithm for Oracle #202707
Replies: 2 comments 1 reply
-
|
I'm curious about this too. |
Beta Was this translation helpful? Give feedback.
-
|
I had a look through the linked repo. One detail that may save you some time: it is a Java stored procedure with PL/SQL wrappers, not a PL/SQL BCrypt implementation. There is an open issue from someone using it on Oracle 19c. BCRYPT_MATCHES returned ORA-00902 when called from SQL because the wrapper returns BOOLEAN. They reported getting 1/0 after changing the return type to NUMBER: MHeydari/BCrypt-algorithm-in-Oracle-plsql#1 The embedded BCrypt code also only accepts I have not tested the full package on 19c myself, so I would not call it a confirmed solution. Are you mainly generating new hashes, or checking existing ones? If they already exist, which prefix do they use? |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
🏷️ Discussion Type
Question
Body
I need to implement (use) the BCrypt algorithm in the Oracle database, starting from version 19c and higher.
There is a built-in package DBMS_CRYPTO in Oracle but it uses a different algorithm.
This package appears to be outdated: https://github.com/MHeydari/BCrypt-algorithm-in-Oracle-plsql
Any information greatly appreciated.
Guidelines
Beta Was this translation helpful? Give feedback.
All reactions