1.5 Executing Procedure

This topic describes the systematic instruction to Executing Procedure option.

  1. Login into database using schema user (OBDXSCHEMA).
  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:

      Table 1-1 Feedback

      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; /

Parent topic: Content Upload Configuration (Day 1)