APEX

Hi there

In a page in my Apex3 app, I display a photo. I use the code below:

[img src=#OWNER#.download_photo?p_consultant_id=&P10_CONSULTANT_ID.]

The photo is optional, can be uploaded to the system and is stored in a blob column. However, for the consultants that don't have an uploaded photo, the download_photo procedure (which is based on the example in http://download-uk.oracle.com/docs/cd/B25329_01/doc/appdev.102/b25310/up_dn_files.htm#CIHDDJGF) raises an "invalid blob" error and the photo displays as a broken image link.

Though it is not a big problem, it looks bad (as if something went wrong), and I would like to display an empty square with the words "no photo", or even rather not display anything in such cases.

What is the best way to do this? In the same region I have an upload file field, so hiding the whole region is not an option... I wonder if there is a CSS property to do this?

Or maybe there is a way, in my procedure, to set the image to be empty?

Thanks!
Luis