PL/SQL (MOSC)

MOSC Banner

ORA-28234 Error - Key Lenght Too Short

edited Oct 24, 2017 6:57AM in PL/SQL (MOSC) 6 commentsAnswered

Hello,

I have to code password encrypt and decrypt mechanism for a custom application.  The encryption routing is working fine. However, when I have to decrypt the encrypted  value I run into the error.

Below is my Encrypt code -- This is working as expected.

PROCEDURE ENCRYPTO (p_normal IN VARCHAR2, p_encrypted OUT RAW)
AS
VARCHAR2 (10) := p_normal;
VARCHAR2 (10);
RAW (2000);            -- stores encrypted binary text
RAW (2000);            -- stores decrypted binary text
NUMBER := 256 / 8;   -- key length 256 bits (32 bytes)
RAW (32);             -- stores 256-bit encryption key
PLS_INTEGER
:=                                           -- total encryption type

+ DBMS_CRYPTO.CHAIN_CBC
+ DBMS_CRYPTO.PAD_PKCS5;
RAW (16);
BEGIN

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center