I want to create an item on form based on BLOB column and upload images on this.
At the same time , I want to display this image into the same item or another item at the same form.
Please, give me an actin plan about doing that.
Oracle APEX version: 4.2
Oracle Apex Environment: Full development environment
Oracle Apex installation scenario: Embedded PL/SQL Gateway
Oracle DB version: 11g XE
Operating System: Windows 7 (64b)
it's an german article, however try this. (google translater is your friend )
> I don't need that, I need to view this image as a preview before committing this row
That is not possible. When you upload an image, it is stored in a table. If you don't want the image after uploading, you need to delete it.
There are plenty of examples, e.g.
Answer: Use a Collection.
You must store the image in a table somewhere in the database in order for you to (re)view it in APEX.
So, instead of doing one transaction (ie insert into final table), do two.
HINT: These should be put into a PL/SQL package in order for you to maintain your sanity in the future.