Home/ Questions/Q 340
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-09-07T19:54:46+00:00

DML of BLOB Objects through PL/SQL in Apex 20.1

  • 0
  • 0

We need to insert and update BLOB Images in Oracle Apex through PL/SQL process without using default Create and Apply Changes buttons. Step by step Help and guidance is required P.S. 1. We do not want to add directory 2. We use row id as Primary Key.  

bloboracle apex
Share
Leave an answer

Leave an answer

Browse

12 Answers

  1. For that, I am looking for a solution to insert blob data manually, without submitting the page using PLSQL, APEX_APPLICATION_TEMP_FILE works only when you submit the page.

  2. There is no issue if you have multiple forms on a single page.

    Multiple forms will have multiple processes on the process tab.

    When you save, all processes will execute.

    You can do the same thing by writing processes instead of multiple dynamic actions, and on-page submit it will do the same task as the dynamic action is doing.

    Or can you explain why you are not able to use the page submit because of multiple forms? What issue are you facing?

  3. I have a report with a form of employee details.
    so to update the employee details, we click on the edit icon of the report.

    And it opens a page having employee form where we can perform DML.

    EMPLOYEE FORM: https://drive.google.com/file/d/1ABxSvn8hYHYg_ut95FDLaXIglvgXoL97/view?usp=sharing

    I have created another form for entering documents details for that particular employee on the same page.

    Though separate processes are being created for each form.
    I have also configured a specific form region for Form-Auto. Row. Process for the documents.
    and save button to perform database insert on page submit for docments.

    It gives an error that empoyee_id constraints are violated.
    and this suggests that the employee form is performing an insert, not the document.

    DOCUMENT FORM: https://drive.google.com/file/d/1dZiYYk3dP99fZpEQVyygNnI_LshLA9Bl/view?usp=sharing

    • Ok, your issue is, how to identify that the insert is happening or update, because the process will run according to the button assignment.

      So if you have multiple forms, then you have to change your UI, I mean instead of the display region, use Tabs and create two sets of buttons Create and Update for every form in Tab.

      And these buttons will be displayed according to the server-side condition based on the PK value.

      Now you will have to run the every process on specific buttons only. For example, you will set a particular process as below:

      Server-side condition:

      Request contains in the value:

      Create_EMP_Button,Update_EMP_Button

      Suppose you have an EMP form, containing two buttons for insert and update, then its DML process will run only when these buttons will be clicked.

      And only one button will be visible at a time due to the PK server-side condition.

      You getting my point?

  4. This answer was edited.

    No Sir I Want How To Save Blob Like

    Insert into inv_item (itemid,itemname,itempic) 
      values (  :P2_ITEMID,:P2_itemname,:P2_Itempic?????);

  5. Meaning, you want to save immediately after uploading the image file without clicking on any button?

    If so, then you can create a dynamic action on the file browse item and select the event Change. Set the action Submit page.

    That is all; now, when you will upload an image immediately after the page will submit, and the default form process will run, and your changes will be saved automatically.

    If you have something different requirement, then please explain what kind of form page you want to develop?