Need to create cases using the JSON stored as BLOB in an External Data base.

Pega is not reading Blobs from External database into properties.

CREATE TABLE INCOMING_REQUEST (   REQUEST_ID      NUMBER(10)                    NOT NULL, ==> Primary Key   PROCESS_NAME        VARCHAR2(50 BYTE)             NOT NULL,   PAYLOAD_OBJECT    BLOB    NOT NULL,   ISPROCESSED         VARCHAR2(1 BYTE)              NOT NULL,   WOID            VARCHAR2(128 BYTE) ) insert into incoming_request    values ( 1,'College of Arts',utl_raw.cast_to_raw ( '{   "JobRole": "Professor",   "CaseData": [     {       "StaffName": "Ramya",       "Type": "Economics department",       "hireDate": "2002-06-07T00:00:00"     },     {       "LegalName": "John",       "type": "Public Accountant",       "hireDate": "2002-06-07T00:00:00"     }   ] }' ),'N','JobRole-1');

The PAYLOAD_OBJECT BLOB has the JSON data inserted.

Need to  create cases using the PAYLOAD_OBJECT JSON in Pega.

1)We tried to create the external Table as a datatype and expose the Column for Payload. It doesn't support larger requests due to varchar limitation. We tried updating the data type to BLOB in the DB Column but it doesn't fetch any data.

2) We tried the Connector Metadata setup. But the Blob couldn't be mapped to any Property type and always erroring as "

• .PAYLOAD_OBJECT: PAYLOAD_OBJECT pegadata APP_DATA.INCOMING_REQUEST" Java Object: (null)

Anyone who has worked on similar requirements please share ideas to overcome this.