储存过程 in invalid

[xiatianPHP]

储存过程如下
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里面建了，报上面的错

[ssqtjffcu]

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

[「已注销」]

1,一楼说了定义变量类型，不要加()大小
2,sequence需要定义，不是拿来就可以nextval的

[秋雨飘落]

储存过程如下
create or replace procedure IC_GETSEQUENCENUM
(
SEQUENCENAME in varchar2(100),
SEQNUM out number
)

[iqlife]

[Quote=引用楼主 的回复:]
储存过程如下
create or replace procedure IC_GETSEQUENCENUM
(
SEQUENCENAME in varchar2(100),
SEQNUM out number
)
as
begin
select SEQUENCENAME.nextval into SEQNUM from dual;

end……
[/Quote]

肯定报错啊，你是想得到序列的值吧，如果传入序列的名称的话，要用动态SQL执行才不会报错（execute immediate ......)，不然认不到序列sequence的名称