function is in an invalid state,该如何解决
function is in an invalid stateSQL codecreate or replace function city2region(quxian_id number)retu
function is in an invalid state
SQL codecreate 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 报错了,请问怎么回事啊?
[解决办法]函数有语法错误!
[解决办法]仔细看看,就能发现错误,呵呵