Oracle创建function函数

 create or replace function getid(newId in number)
   return number
 is
   isInsert number(8);
 begin
   isInsert:=0;
   --查出v_calling_type
   select flow_id into isInsert from apply_flow1@dblinktojm where flow_id=newId;
   return isInsert;
 exception
   when others then
   return 0;
 
 end getid;

 

posted @ 2021-08-02 15:17  ALin_Da  阅读(1310)  评论(0编辑  收藏  举报