create or replace procedure whq_xml_insert(client in varchar2,sheet in varchar2,type1 in number,pageby in varchar2,
pageorder in number,rowname in varchar2,rowname_e in varchar2,roworder in number,
colname in varchar2,colorder in number,value1 in number,value2 in number,pageby2 in varchar2)
is
begin
v_sql:='insert into tmp_whq_xmlreport values(:1,:2,:3,:4,:5,:6,:7,:8,:9.:10,:11,:12,13:)';
execute immediate v_sql using client,sheet,type1,pageby,pageorder,rowname,rowname_e,roworder,colname,colorder,value1,value2,pageby2;
end whq_xml_insert;
------解决思路----------------------
注意将代码格式化,方便阅读:
create or replace procedure whq_xml_insert(client in varchar2,
sheet in varchar2,
type1 in number,
pageby in varchar2,
pageorder in number,
rowname in varchar2,
rowname_e in varchar2,
roworder in number,
colname in varchar2,
colorder in number,
value1 in number,
value2 in number,
pageby2 in varchar2) is
v_sql varchar2(2000);
begin
v_sql := 'insert into tmp_whq_xmlreport values(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13)';
execute immediate v_sql
using client, sheet, type1, pageby, pageorder, rowname, rowname_e, roworder, colname, colorder, value1, value2, pageby2;
end whq_xml_insert;