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.daimami.com/search?q=177537
------解决方案--------------------
一、