Upload and View a File (image/pdf/doc) in a List of Oracle Apex Page

Uploading and viewing a file (image/pdf/doc) in the Oracle Apex page is sometimes problematic if we miss steps that we should do. But this is very easy and simple thing as I have experienced. I have kept the process in very easy 8 steps, kindly go through them, they are really easy and will take few minutes only!

1. INSERT 5 FIELDS IN DATA FOR FILE UPLOADING:

When we have decided to uplaod a file, we should have few db columns in our table:


FILE_LOB
FILE_NAME
FILE_MIMETYPE
FILE_UPDATEDATE
FILE_CHARACTERSET

here, the file_name is for holding the full image name (with extension) and file_characterset is used for determining whether it is a 32 bit or 64 bit characterset file.
Continue reading “Upload and View a File (image/pdf/doc) in a List of Oracle Apex Page”