Hi Mates,

I want to build a report showing employee image with his/her record. Actually when I am just writing SQL like below:

SELECT A.PERSON_NUMBER,

B.DISPLAY_NAME,

C.IMAGE

FROM PER_ALL_PEOPLE_F A,

PER_PERSON_NAMES_F B,

PER_IMAGES C

WHERE A.PERSON_ID = B.PERSON_ID

AND B.NAME_TYPE='GLOBAL'

AND A.PERSON_ID = C.PERSON_ID

and A.person_id = <person_id>

this query is working fine but when I am using this sub query or PER_IMAGES table in my main query which is basically showing the succession plan it is showing this error: ORA-00932: inconsistent datatypes: expected - got BLOB. Please help in this regard.