您的位置: 首页  >  IT文章  >  Oracle管理  >  function is in an invalid state,该如何解决

function is in an invalid state,该如何解决

分类: IT文章 • 2022-08-16 00:20:39
function is in an invalid state
SQL code

create or replace function city2region(quxian_id number)
return number
as 
v_id number;
begin 
 select region_id into v_id from region where city_id = quxian_id;
 return v_id
 end


select quxianchadishi(123) from dual,jiu 报错了，请问怎么回事啊？

------解决方案--------------------
函数有语法错误！
------解决方案--------------------
仔细看看，就能发现错误，呵呵

相关推荐