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 188.8.131.52, but Oracle say BLOBS are still not supported in that release. It will be fixed in 184.108.40.206 and it will be backported into 220.127.116.11.11
In the meantime we have abandoned showing Photo's in any of our reports.