Primary Key Unique Constraints report this ad.The views expressed on this blog are my own and do not necessarily reflect the views of Oracle Corporation. ![]() Output_string := UTL_I18N.RAW_TO_CHAR (decrypted_raw) Workaround about output_string is applied: Output_string := UTL_I18N.RAW_TO_CHAR (decrypted_raw, ‘A元2UTF8’) Per your comments and DOC ID – UTL_I18N.RAW_TO_CHAR Is Failing With ORA-01890 In 12.2 When src_charset Value Is Different From DB Character Set (Doc ID 2456883.1), I tried below options but still i don’t see the password in plain text. ORA-06512: at “SYS.DB_LINK_PASSWORD_DECRYPT”, line 94 ORA-06502: PL/SQL: numeric or value error Output_string := UTL_I18N.RAW_TO_CHAR ( utl_raw.substr( decrypted_raw, 2,to_number( rawtohex( utl_raw.substr( decrypted_raw, 1, 1 ) ), ‘XX’ ))) I am receving below error when i tried to decrypt after creating the procedure as it was. TNS for 64-bit Windows: Version 12.2.0.1.0 – Production 0 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production 0 Thanks Adric Norris for you contribution. UPDATE : The script can now be run from sqlplus and the noise from the recovered value has been eliminated. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |