存储过程，不知道哪儿错了，求指教

Question

sql存储

Answer 1

注意将代码格式化，方便阅读：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;

Answer 2

注意将代码格式化，方便阅读：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;
  解决了，谢谢了