How to load the encrypted whole file into a table using ODI(Oracle data Integrator)

Hi Team,

Is there a way to load the whole of the encrypted file via ODI as a BLOB column into a table.

Plan is to load the whole encrypted file into a table using ODI and then do the decryption using plsql scripts to decrypt the file. The decrypted data will be loaded into staging table.

Any insight will be helpful.