存储过程创建
------------------------------1
create or replace procedure wf_obj_insert_gctk(p_in_wfid in integer,p_in_projcode in varchar2,p_in_banme in varchar2) as
p_ffrdid integer;---项目文件夹ID
p_zfrdid integer;---项目下文件夹ID
p_idpath varchar2(100);---实际的IDPATH
p_typepath varchar2(100) ;
begin
p_typepath := '1\2\2\2\2\6\';
if(0=0) then
dbms_output.put_line('1111111='||p_typepath);
else
dbms_output.put_line('1111111='||p_typepath);
end if;
end;
-------------------------2
create or replace procedure wf_obj_insert_gctk(p_in_wfid in integer,p_in_projcode in varchar2,p_in_banme in varchar2) as
p_ffrdid integer;---项目文件夹ID
p_zfrdid integer;---项目下文件夹ID
p_idpath varchar2(100);---实际的IDPATH
p_typepath varchar2(100) := '1\2\2\2\2\6\' ;
begin
if(0=0) then
dbms_output.put_line('1111111='||p_typepath);
else
dbms_output.put_line('1111111='||p_typepath);
end if;
end;
---------------------------------3
如果存储过程报错,则使用Plsql调试会自动提示错误
红色处理了就不会报错了: