创建存储过程的语句:
create or replace procedure hello(hid in varchar(2),hmain_id out varchar(20))
as
begin
select main_id into hmain_id from tb_main where id=hid;
end hello;
/
报错以下错误:请问为什么啊?该怎么解决?
...全文
1456打赏收藏
Oracle11g 创建存储过程报错,请帮我看看~
创建存储过程的语句: create or replace procedure hello(hid in varchar(2),hmain_id out varchar(20)) as begin select main_id into hmain_id from tb_main where id=hid; end hello; / 报错以下错误:请问为什么啊?该怎么解决?
create or replace procedure hello(hid in varchar(2),hmain_id out varchar(20))
改为,不要指定长度
create or replace procedure hello(hid in varchar,hmain_id out varchar)