The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_met_insert_clob clob;
l_opt_insert_clob clob;
l_mod_insert_clob clob;
l_met_insert_clob := null;
l_opt_insert_clob := null;
l_mod_insert_clob := null;
dbms_lob.createtemporary(l_met_insert_clob,true);
dbms_lob.open(l_met_insert_clob,dbms_lob.lob_readwrite);
l_met_insert_clob := l_met_clob1;
dbms_lob.append(l_met_insert_clob,l_met_clob2);
dbms_lob.append(l_met_insert_clob,l_met_clob3);
dbms_lob.append(l_met_insert_clob,l_met_clob4);
dbms_lob.createtemporary(l_opt_insert_clob,true);
dbms_lob.open(l_opt_insert_clob,dbms_lob.lob_readwrite);
l_opt_insert_clob := l_opt_clob1;
dbms_lob.append(l_opt_insert_clob,l_opt_clob2);
dbms_lob.createtemporary(l_mod_insert_clob,true);
dbms_lob.open(l_mod_insert_clob,dbms_lob.lob_readwrite);
l_mod_insert_clob := l_mod_clob1;
dbms_lob.append(l_mod_insert_clob,l_mod_clob2);
update qpr_report_type_lines
set
report_type_line_name = P_REPORT_TYPE_LINE_NAME,
report_metadata = l_met_insert_clob,
report_modifiers = l_mod_insert_clob,
report_options = l_opt_insert_clob,
aspect_ratio = to_number(P_ASPECT_RATIO),
report_type_line_code = P_REPORT_TYPE_LINE_CODE,
width = to_number(P_WIDTH),
last_update_date =sysdate,
last_updated_by = l_user_id,
last_update_login = 0
where report_type_line_id = to_number(P_REPORT_TYPE_LINE_ID);
insert into qpr_report_type_lines
(REPORT_TYPE_LINE_ID,
REPORT_TYPE_LINE_NAME,
REPORT_TYPE_LINE_CODE,
ASPECT_RATIO,
WIDTH,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
REPORT_OPTIONS,
REPORT_METADATA,
REPORT_MODIFIERS
)
values
(to_number(P_REPORT_TYPE_LINE_ID),
P_REPORT_TYPE_LINE_NAME,
P_REPORT_TYPE_LINE_CODE,
to_number(P_ASPECT_RATIO),
to_number(P_WIDTH),
sysdate,
l_user_id,
sysdate,
l_user_id,
0,
l_opt_insert_clob,
l_met_insert_clob,
l_mod_insert_clob
);
dbms_lob.close(l_met_insert_clob);
dbms_lob.close(l_opt_insert_clob);
dbms_lob.close(l_mod_insert_clob);