Hello,
Currently I load csv files to a table through an apex user interface. The table that contains the data is constructed as follows:
TBL_UPLOADS
(
ID NOT NULL
BLOB_CONTENT BLOB
MIME_TYPE VARCHAR2(255)
FILENAME VARCHAR2(255)
LAST_UPDATED DATE
CHARACTER_SET VARCHAR2(128)
)
I have an Automatic Row Processing (DML) process that defines which operations are allowed on the table. In my case it's only "Insert". I also specified a condition here that the process only runs when the button UPLOAD is pressed. I also filled in all source attributes such as Item Containing Primary Key Column Value (Value Required) etc.
I also have an UPLOAD button. In the section Action When Button Clicked for this button the following applies:
Action: SUBMIT PAGE
Execute validations: YES
Database action: SQL INSERT ACTION
The whole thing works just fine. I just want to do the database action manually because I want it to do more stuff then just inserting. First thing I need to do is to replicate it. This is where I am puzzled. Now I know I need to use a dynamic action for this. I am just not sure how to insert the values in my tbl_uploads (the insert query itself). I have reviewed examples such as Denes Kubicek - ApEx Solutions but I am not using the wwv_flow_files table. Besides, it seems like a chicken and egg story to me because I need to insert data in my table (uploads) first.
Can anyone get me back on track?