Encryption/Decryption

[ArndW]

Prasad,

when you say that it isn't working "from ETL" does that mean from DataStage? Which stage and and how are you calling the SQL? It might be that you are doing a second encryption by misteak <sic>.

[ArndW]

I find it odd that the encrypt has 4 parameters (unabalanced in your post) and the decrypt only 1. Is that correct?

[kumar_s]

Hi Prasad,
Not necessary to post twice, Pls delete the other post.

[ukyrvd]

Hi Prasad,
Not necessary to post twice, Pls delete the other post.

Hi Kumar,
Sure. Next time, i will try not to post twice.

Thanks,

[ukyrvd]

I find it odd that the encrypt has 4 parameters (unabalanced in your post) and the decrypt only 1. Is that correct?

Sorry, missed copying full query. I have used the correct/balenced query:

Code: Select all

SELECT xxxx, (RPAD (xxxx, LENGTH (xxxx) + 8 - MOD (LENGTH (xxxx), 8), ' '))
  FROM tablet

As entioned briefly earlier,

The query when ran @ SQL prompt working fine and encrypting the data correctly. And when we apply decrypt on that we are getting original value(space padded) back.

But when I execute from a DataStage job the encrypted text is different from what we got from the execution at SQL prompt. As a result the decrypt is not working either. The ETL job used is :

Code: Select all

         OCI------------------------------------------->OCI
    (select query posted earlier)                   (insert to table)

The output from dbms_obfuscation_toolkit is defined as varchar2 and so we are using that setting on our ETL column definition as well. I am wondering if this should be little different.

thanks