16.8.2.5.4.5.2 Inserting Photos with Titles

Insert the staged photos and titles into the permanent break room photos table.

Once all the grid changes are saved in the collection, the second child process Save Collection Images uses an Invoke API to call the SAVE_UPLOADED_BREAKROOM_PHOTOS procedure. It uses the EBA_DEMO_WOODSHR_TEMP_PHOTOS view insert all the temporary photos and titles into the EBA_DEMO_EMP_BREAKROOM_PHOTOS table.

-- in package eba_demo_woodshr_file
procedure save_uploaded_breakroom_photos 
is 
begin 
    insert into eba_demo_emp_breakroom_photos(
           empno,
           mime_type,
           file_name,
           title,
           image) 
    select empno, 
           mime_type,
           filename,
           title,
           photo
      from eba_demo_woodshr_temp_photos; 
end save_uploaded_breakroom_photos; 

Figure 16-82 Invoke API Calls Package Procedure to Save Temporary Photos

Description of "Figure 16-82 Invoke API Calls Package Procedure to Save Temporary Photos"