Hi Saikat ,

Can you please tell me column type in your table in which images are getting saved and property type in SmartObject  through which data get saved in database . 

As per requirement it should be like :

In Tables - nvarchar(MAX)

In SmartObject  - File type 

Hope it will work in your case also.!!!!!

Regards,

Ruchi

Hi Ruchi,

The table is in Oracle database with field type = BLOB (in oracle images are stored in Binary Large Objects type field)

The Smart Object generated is unable to locate the BLOB field, but it is locating the other fields in the table.

I wonder if this is a constraint in K2 ?

Thanks - Saikat

Hi Saikat,

After doing doing more reseacrh on this i got to know that some oracle data type are not supported in K2 smartObject .

The following Oracle Data Types are not supported and must not be surfaced as SmartObject properties:

• RAW
• BLOB
• Binary
• BFile
• LONG RAW

Please find the URL for further refrences. 

URL : http://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.9/webframe.html#the_k2_oracle_service.html

Regards,

Ruchi 

Hi Ruchi,

Thanks a lot for your help. Yes, Oracle BLOB cannot be accessed by K2, So I had to resort to registering the image in the K2 server and adding that using the Image label in the K2 Form.