oracle存储过程创建-----gxy

存储过程创建

------------------------------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调试会自动提示错误

红色处理了就不会报错了：