sql - Trouble With Encryption in Oracle11g -

-

i working on lab attempting encrypt dummy ssn , provide output in sql plus shows unencrypted ssn, encrypted ssn, , decrypted ssn.

the value encrypting 555 55 5555, decrypted value appears 33353335333532303335333532303335333533353335. i'm not quite issue lies, since appears @ least decryption occurring. suggestions appreciated. sql below

set serveroutput on declare    ssn varchar2(200) := '555 55 5555';  ssn_decrypt varchar(200);  ssn_raw raw (200) := utl_raw.cast_to_raw(ssn);  num_key_bytes number := 256/8;  key_bytes_raw raw (32);  encryption_type pls_integer := dbms_crypto.encrypt_aes256  + dbms_crypto.chain_cbc  + dbms_crypto.pad_pkcs5;  encrypted_raw raw (2000);  decrypted_raw raw(2000);    begin     dbms_output.put_line('the unencrypted ssn is: ' || ssn);     key_bytes_raw := dbms_crypto.randombytes (num_key_bytes);     encrypted_raw := dbms_crypto.encrypt          (             utl_i18n.string_to_raw (ssn),              typ => encryption_type,             key => key_bytes_raw         );  decrypted_raw := dbms_crypto.decrypt     (         src => encrypted_raw,         typ => encryption_type,         key => key_bytes_raw     );  ssn_decrypt := utl_i18n.raw_to_char (decrypted_raw, '555 55 5555'); dbms_output.put_line('the encrypted ssn is: ' || rawtohex(utl_raw.cast_to_raw(encrypted_raw)));   dbms_output.put_line('the decrypted ssn is:' ||   rawtohex(utl_raw.cast_to_raw(decrypted_raw))); end; /

the example found dbms_crypto documentation works flawlessly. copy , you'll good.

one issue don't define correct parameters in char vs. raw conversions. should be:

 utl_i18n.string_to_raw(ssn, 'al32utf8')  utl_i18n.raw_to_char(decrypted_raw, 'al32utf8');

note example assumes database character set al32utf8. if not have make conversion too.


Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more