首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

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

2012-03-24 
function is in an invalid stateSQL codecreate or replace function city2region(quxian_id number)retu

function is in an invalid state

SQL code
create or replace function city2region(quxian_id number)return numberas 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 报错了,请问怎么回事啊?

[解决办法]
函数有语法错误!
[解决办法]
仔细看看,就能发现错误,呵呵

热点排行