EBS Customizations (MOSC)

MOSC Banner

DBMS_OBFUSCATION_TOOLKIT.DESdecrypt function returns with some invisible values

edited Jul 18, 2018 3:01PM in EBS Customizations (MOSC) 1 commentAnswered ✓

Hi,

We are in the process of encrypt/decrypt password file.

I have encrypted the passwords in the file and decrypted the value during our interface process to authenticate to move further and its returning with some invisible values.

I checked the length of the return values it shows in the difference of 4,8 and 16.

I have not seen any values in TOAD, SQL Plus and Unix prompts. But it have some value end of the return value. So because of this authentication failing to move further.

l_decrypt := utl_raw.cast_to_varchar2( hextoraw(trim(l_value1)));

DBMS_OBFUSCATION_TOOLKIT.DESdecrypt (

Tagged:

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