我用单独的 select orderlist_ordernr.nextval from dual; 能擦到序列值。用下面的函数编译器告述我说序列不存在。为升么?create or replace function hr.get_order_ordernr(i out number)
return number
is
begin
select orderlist_ordernr.nextval into i from dual;
return i;
end;
return number
is
begin
select orderlist_ordernr.nextval into i from dual;
return i;
end;
还是这样创建的,不同表空间,不一样的
create sequence hr.orderlist_ordernr ……