Symptoms
The default Oracle data types for holding files, such as images and documents, LOBs. How do these translate to K2.
Diagnoses
The BLOB data type is not supported in K2, as described in the following documentation:
https://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.9/webframe.html#The_K2_Oracle_Service.html
Resolution
CLOB, however, is still supported, though you should note that the characters within any document stored within a CLOB field must use the database character set exclusively.
By default, the Oracle service broker defaults the CLOB data type to a memo field in K2. In order to change this, you will need to generate the Oracle SmartObject, then edit the SmartObject itself and change the type of your CLOB field to be an image/file/whatever you want it to be. This should unencode the file into whatever type you need it to be.
