Hi,
Under Oracle APEX 24.2.10 I have a page on application 108 p.24. The form display a new record on the table AD_TACHE. The table as items for uploading a file :
The user can successfully select a file using the FILE item.
I have created a button “Supprimer Document” (Delete document) if the user want to delete this document from the form.
When the user click on the button “Supprimer Document” wich submit the page, I have created a PL/SQL process (the first one) that set to null the items necessary for a document inside on the record edited and before the DML treatement set the columns of the table AD_TACHE to the value null. Then the form is automatically updated with a DML treatement on the form.
UPDATE AD_TACHE set created_date := null WHERE id = :p24_id;
UPDATE AD_TACHE set MIMETYPE := null WHERE id = :p24_id;
UPDATE AD_TACHE set FILE := null WHERE id = :p24_id;
UPDATE AD_TACHE set FILENAME := null WHERE id = :p24_id;
:P24_created_date := null ;
:P24_MIMETYPE := null ;
:P24_FILE := null ;
:P24_FILENAME := null;
But it does not work, the columns are not set to null from the record. They remains populated in the record :
I dont'understand why they are are not set to null with the SLQ Pocess I have done. The items that I set to null are still populated when I click on the button “SUPPRIMER_DOCUMENT” :
Thank you for your suggestions.
Best regards.