The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_instruction_files
IS
l_err_loc PLS_INTEGER;
DELETE FROM icx_por_template_files;
INSERT INTO icx_por_template_files
(filename, usage, template_type, description)
SELECT 'Readme_Spreadsheet.htm', 'TXT', 'ALL', 'Instructions for TXT upload.'
FROM dual;
INSERT INTO icx_por_template_files
(filename, usage, template_type, description)
SELECT 'Readme_XML.htm', 'XML', 'ALL', 'Instructions for XML upload.'
FROM dual;
INSERT INTO icx_por_template_files
(filename, usage, template_type, description)
SELECT 'Readme_cXML.htm', 'CXML', 'ALL', 'Instructions for cXML upload.'
FROM dual;
INSERT INTO icx_por_template_files
(filename, usage, template_type, description)
SELECT 'Readme_CIF.htm', 'CIF', 'ALL', 'Instructions for CIF upload.'
FROM dual;
INSERT INTO icx_por_template_files
(filename, usage, template_type, description)
SELECT 'Readme_Schema.htm', 'SCHEMA', 'ALL', 'Instructions for schema upload.'
FROM dual;
INSERT INTO icx_por_template_files
(filename, usage, template_type, description)
SELECT 'Readme_Converter.htm', 'CONVERTER', 'ALL', 'Instructions for converter.'
FROM dual;
'Exception at ICX_CAT_DOWNLOAD_FILES_PVT.insert_instruction_files(' ||
l_err_loc || '), ' || SQLERRM);
END insert_instruction_files;