存储过程变量类型定义与表字段一致
create or replace procedure pro_getchart(chart_id in number, start_time in varchar2, end_time in varchar2) is temp_id dic_chart.chart_id%TYPE; begin select t.chart_id into temp_id from dic_chart t where t.chart_id = chart_id; end pro_getchart;