Solved

Conversion from base64 encoded string in java to varchar in oracle

Posted on 2004-09-06
1
1,607 Views
Last Modified: 2012-05-05
hi,

We have encrypted a value in java using des3 with a specific key.  We have converted this byte array to
a base64 encoded string value.

Now we want to decrypt this data using des3 in oracle.
To do this do we
1) convert String to raw value using UTL_RAW.CAST_TO_RAW(base64String)
2) Decode base 64 raw value using UTL_DECODE.BASE64_ENCODE
3) Decrypt using des3 oracle passing in key, and value returned from 2.
4) Convert to varchar2 using UTL_RAW.CAST_TO_VARCHAR2
0
Comment
Question by:inzaghi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 23

Accepted Solution

by:
seazodiac earned 500 total points
ID: 11990536
I think you should explore what DBMS_OBFUSCATION_TOOLKIT package offers to you.

it has DBMS_OBFUSCATION_TOOLKIT.DECRYPT() procedures , overloading procedures to decipher the byte array encoded using JAva DES3 algorithm
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Listener Not Starting 11 65
pl/sql - query very slow 26 87
having some issue on pl sql procedure 1 29
ORA-02288: invalid OPEN mode 2 81
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question