SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Encryption and Decryption using AES Algorithm

Priyanka PawarSep 17 2012 — edited Jan 11 2013

Hi,

For an application we are working on we have AES encryption algorithm written at iOS side. Input string will get encrypted from iOS side and using Webservices it is communicating with Database. I have plsql code written using "DBMS_CRYPTO" package for encryption and decryption using AES algorithm.

My requirement is to decrypt the string i received from iOS side using AES algorithm. We are using same Algorithm, Key, Cipher Chain Mode and Padding form at both Database and iOS side.

Issue is iOS sends encrypted string in BYTE format and from database side "DECRYPT" function takes input in RAW format. How can i convert encrypted string coming in "BYTE" format to "RAW" format ??
e.g.
Input String: PriyankaP
Encrypted String coming from iOS : TTl2kEkCV2zh8ocac4QQlQ==

How can i convert it to RAW data type and get decrypted string using PL/SQL code? Please guide..

Regards,
Priyanka

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 8 2013

Added on Sep 17 2012

6 comments

2,897 views