1.5 Executing Procedure

  1. Login into database using schema user (OBAPISCHEMA).
  2. Template for procedure call is as given below:
    • For Feedback:
      begin  
              load_file_to_content(<Variable name for File’s registered path>,
              <Files’ Name>,<Content ID>);
      end;/
  3. Execute commands given under column ‘Proc Execution Statement’.
    • For Feedback Proc Execution Statement:
      File Name Proc Execution Statement
      Heart-fill.svg begin load_file_to_content('CONTENT_FILES','heart-fill.svg', ‘${contentId1}’);end;/
      Star.png beginload_file_to_content('CONTENT_FILES','star.png ', ‘${contentId2}’);end;/
      Thumbs-up.svg beginload_file_to_content('CONTENT_FILES','thumbs-up.svg ', ‘${contentId3}’);end; /