In PL/SQL, how do I write an update_text_file procedure to upload file names that match a partial item_title value?

The update_text_file procedure should take one pv_item_title parameter and update all item_desc column values with the contents of files with matching file names.

The update_text_file procedure should also contain the following:

Accept a single pv_item_title parameter, which should use a VARCHAR2(30) data type. Use a dynamic cursor that accepts a partial string value for the item_title column. Call the load_clob_from_file procedure for every row returned from the item table that has a text_file_name that matches the file_name values from the file_list external table.