Breadcrumb

File & Image Uploader Pro supports uploading and storing files directly into custom tables and allows you to define the custom columns where file metadata will be saved.

Furthermore, it supports foreign key columns and item definitions. Images will be ready in your table without the need to further manipulate metadata.

In order to implement this functionality, the following settings need to be set:

Attribute Name	Example Attribute Value	Description
Storage Type	Custom Table	-
PK Column	ID	Varchar2/Number column where the primary key will be returned. The Primary Key (PK) must be processed with a Before Insert Trigger. The column value is used for after upload processing.
MIME Type Column	MIME_TYPE	Varchar2 column where the MIME type will be saved.
Filename Column	FILENAME	Varchar2 column where the name of the file will be saved.
FK Item	P4_FOREIGN_KEY	Item where the foreign key value is calculated. Values has to be in session state before loading the upload form.
FK Column	FK_ID	Varchar2/Number column where the foreign Key will be saved.
Date Column	CREATED_ON	Optional date field where the upload date will be saved.
Collection / Table Name	IUP_IMAGES	Name of the destination table where the images will be saved.
BLOB Column	BLOB_CONTENT	BLOB Column where the contents of the file will be saved.

The following query demonstrates how to retrieve data from a custom table.


select
  id,
  fk_id,
  filename,
  mime_type,
  dbms_lob.getlength(blob_content) image 
from 
  iup_images

Try it

Foreign Key

style

Breadcrumb

Introduction

Settings

Query Example

Try it

Upload Images and Store in a Custom Table

Verify the Custom Table