oracle sqlplus 写的一个存储过程，看看有什么问题
create or replace procedure InsertPointData 
(
jl_POINTID in varchar2,
jl_POINTNAME in varchar2,
jl_POINTTYPE in varchar2,
jl_VIDEOIP in varchar2,
jl_METERTYPE in varchar2,
jl_status out integer,
jl_hint out varchar2)
is
pointid varchar2(88),
pointname varchar2(30),
pointtype varchar2(10),
videoip varchar2(20),
metertype varchar2(20);
begin
insert into jl_pointinfo
(pointid, pointname,pointtype,videoip,metertype) 
values
(jl_POINTID, jl_POINTNAME,jl_POINTTYPE,jl_VIDEOIP,jl_METERTYPE);
commit;
  jl_status:=0;
  jl_hint:='添加成功';
exception
  when others then
  o_status:=-1;
  o_hint:='添加失败';
end ;

------解决方案--------------------
我的异常网推荐解决方案：oracle存储过程,http://www.aiyiweb.com/oracle-develop/177537.html
------解决方案--------------------
一、

探讨

pointid varchar2(88),
pointname varchar2(30),
pointtype varchar2(10),
videoip varchar2(20),