储存过程如下
create or replace procedure IC_GETSEQUENCENUM
(
SEQUENCENAME in varchar2(100),
SEQNUM out number
)
as
begin
select SEQUENCENAME.nextval into SEQNUM from dual;
end IC_GETSEQUENCENUM;
在PL/SQL里面建了,报上面的错
create or replace procedure IC_GETSEQUENCENUM
(
SEQUENCENAME in varchar2(100),
SEQNUM out number
)
as
begin
select SEQUENCENAME.nextval into SEQNUM from dual;
end IC_GETSEQUENCENUM;
在PL/SQL里面建了,报上面的错
create or replace procedure IC_GETSEQUENCENUM(SEQUENCENAME in varchar2,--(100), --这里只需要定义变量类型,不需要定义大小
SEQNUM out number) as
begin
select SEQUENCENAME.nextval into SEQNUM from dual;
end IC_GETSEQUENCENUM
2,sequence需要定义,不是拿来就可以nextval的
create or replace procedure IC_GETSEQUENCENUM
(
SEQUENCENAME in varchar2(100),
SEQNUM out number
)
肯定报错啊,你是想得到序列的值吧,如果传入序列的名称的话,要用动态SQL执行才不会报错(execute immediate ......),不然认不到序列sequence的名称