Hi all!

Tell me please what I need to configure in my own external table to save BLOB?

Table columns is

ID (Autoincrement), DEALID, MESSAGECODE, PZPVSTREAM, CREATEDDATETIME (Current timestamp), PZINSKEY

Steps of my activity is

1) Page-New create page of class that map to table

2) Property-Set

a. .DealID = "AA-123" (This field is exposed)

b. .MessageCode = "121" (This field is exposed)

c. .MessageBody = "My test message" (This field is not exposed)

3) Obj-Save with Write now option

And on the third step I get an error "Database column MessageBody in database pegadata, table PRPC.TEMPTABLE has an unknown type: JDBC Type 2004".

I think that all exposed properties saved separately and all of other properties goes to BLOB column named PZPVSTREAM, but I was wrong...

Also can you tell me how I can read data from this field?

Thanks in advance!