Update the uploaded file into BLOB Datatype
580163Oct 25 2007 — edited Oct 31 2007Hi All,
I have a table which has a column to store the reference document. I am using Blob datatype for it. I created a report and form to manage this table.
Following the steps in the HOw to Document I am able to upload a file from the form, move it to my required table from APEX_APPLICATION_FILES and also create a download link on the report page.
I have problems in updating the Blob column in the table.
1. when I edit the row I don't see the existing file name in the file browse item but when I change the item type to text field I can see the name of the file.
(Note: the field on the form with file browse type is the name of the file not the Blob column itself.)
I am using a trigger to get the requred file from APEX_APPLICATION_FILES.)
2. I am not able to replace the existing file with a new one.
Can anyone please guide me through this?
Thanks in advance.