CREATE OR REPLACE PROCEDURE proc_Inf_Add
(
v_Name in varchar2,
v_Size in number,
v_Tname in varchar2,
v_Text in varchar2,
v_Date in varchar2,
v_ture in blob --oracle中没有image，需要在Inf表中修改这个字段的类型，改为blob即可
)
is
v_Tid number;
begin
select Tid into v_Tid from Type where Tname=v_Tname;
if v_Tid is not null then
insert into Inf(Name,Size,Tid,Text,Date,ture) values(v_Name,v_Size,v_Tid,v_Text,to_date(v_Date, 'yyyy-mm-dd'),v_ture);
end if;
end;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024