当前位置: 代码迷 >> Oracle开发 >> 存储过程,不知道哪里错了,求指教
  详细解决方案

存储过程,不知道哪里错了,求指教

热度:93   发布时间:2016-04-24 06:34:12.0
存储过程,不知道哪儿错了,求指教
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 
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;
  相关解决方案