-
Encrypted string coming with newline character
Hi,
I need to remove the newline character coming for some records in my table.
I am using the following procedure for encrypting ssn....
CREATE OR REPLACE PROCEDURE Encrypt_aj(ID NUMBER,ssn IN VARCHAR2,encrypt_st OUT VARCHAR2)
IS
input_string VARCHAR2(24) :=TO_CHAR(ssn);
key_string VARCHAR2(8) := 'scottsco';
encrypted_string VARCHAR2(2000);
BEGIN
dbms_obfuscation_toolkit.DESEncrypt(input_string => input_string,key_string => key_string,encrypted_string =>encrypted_string);
encrypt_st:=encrypted_string;
INSERT INTO stored_proc_trans_aj VALUES(ID,encrypt_st,SYSDATE);
COMMIT;
END;
/
The data in the table is like this ..
INSTR_ID ENCRYPT_DATA TIME_LOAD
110015781 36¿¿{;+J¿¿ 1/26/2008 5:58:32 PM
110015799 i~S¿@4¿¿¿b 1/26/2008 5:58:32 PM
110016094 ¿M¿
d¿¿¿ 1/26/2008 5:58:32 PM
110019171
,¿x`¿S~¿¿' 1/26/2008 5:58:32 PM
110015781 36¿¿{;+J¿¿ 1/26/2008 5:59:54 PM
110015799 i~S¿@4¿¿¿b 1/26/2008 5:59:54 PM
110016094 ¿M¿
d¿¿¿ 1/26/2008 5:59:54 PM
110019171
,¿x`¿S~¿¿' 1/26/2008 5:59:54 PM
110015781 36¿¿{;+J¿¿ 1/26/2008 6:01:36 PM
110015799 i~S¿@4¿¿¿b 1/26/2008 6:01:36 PM
110016094 ¿M¿
d¿¿¿ 1/26/2008 6:01:36 PM
110019171
,¿x`¿S~¿¿' 1/26/2008 6:01:36 PM
110015781 36¿¿{;+J¿¿ 1/26/2008 6:15:04 PM
110015799 i~S¿@4¿¿¿b 1/26/2008 6:15:04 PM
110016094 ¿M¿
d¿¿¿ 1/26/2008 6:15:04 PM
110019171
,¿x`¿S~¿¿' 1/26/2008 6:15:04 PM
3rd and 4th rows are having newline characters...
If you have faced similar problem , pls. let me know...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|