Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2003
    Posts
    4

    Unanswered: dbms_obfuscation_toolkit giving problem....DB UTF8

    Hi,
    I am using dbms_obfuscation_toolkit for encryption and decryption.(DES)
    platform : SUN SOLARIS 5.8
    Oracle : oracle9i ***UTF8***

    Its encrypting properly and then i am keeping the record in a CLOB but when decrypting i am checking whether its a multiple of 8 and its not.
    Its not properly RPADing and its giving some absurd results.

    before RPAD ing its 85 and after padding its giving 63..

    could anyone pl. help me in this regard..


    Thanks in advance,

    Srinivas.

    NB: this is the output for the decryption code. i am reading from a clob and then decrypting the string.


    -----------> l_Amount 85
    -----------> l_Bufferin
    a¿n‡S¿¿ ¿C¿¿<¿¿¿h¿¿¿¿¿1¿R3b¿¿¿¿¿T$^¿= S¿¿K¿¿I¿t¿¿¿w
    p¿¿
    length of the truncated string -------------> 11
    length of the truncated string -------------> 88
    -----------> l_Amount after padding 63
    entering decryption------------->
    encrypted string ------------->
    a¿n‡S¿¿ ¿C¿¿<¿¿¿h¿¿¿¿¿1¿R3b¿¿¿¿¿T$^¿= S¿¿K¿¿I¿t¿¿¿w
    declare
    *
    ERROR at line 1:
    ORA-20999: ORA-28232: invalid input length for obfuscation toolkit
    ORA-06512: at "TESTAUDITLOG.DECRYPT_ENCRYPTED_DATASRINI", line 57
    ORA-06512: at line 5
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •