I'm trying to create something close to the sample application with some other products. I have a table with BLOB column for the products jpg files. However, I have encountered the following challenge: the preview is not working.
Can someone please advise?
http://127.0.0.1:8080/apex/f?p=101:6:210166173859347::::P6_id_produs:23 id_produs is PK in the products table that contains the BLOB column.
However, if I open the product, I can see the large image on the right:
Well that explains the problem. The url NEEDS to be a viable url to an image -- a procedure needs to be called to (in essence) spit out the blob to a mime-type of jpeg so the browser can display it. Although there are several ways to achieve this -- since you basically see it "working in one place but not another", take a look at how the working image's URL is generated on the page where it's working.. APEX offers an item type that can display an image, but you can also use PLSQL code to insert such in the rendered output anywhere. If none of this helps, there are many hits via google that discuss all of this in the detail you'll need.
This is the link that works. You are right!