Thanks, yes I followed http://docs.oracle.com/cd/E28280_01/bi.1111/e10540/busmodlayer.htm#BGBDBDHI, but when I get to the part of setting the LOOKUP function on th Physical source, only ONE physical source is displayed. I need TWO sources ( The Employee Table, and the Photo LookUp.
I have raised this as an error with Oracle. We are now on OBIEE 184.108.40.206, but Oracle say BLOBS are still not supported in that release. It will be fixed in 220.127.116.11 and it will be backported into 18.104.22.168.11
In the meantime we have abandoned showing Photo's in any of our reports.