Question

oracle存储过程，对象sys. add_region无效，错在哪了？？

create or replace procedure add_region
(
var_number in out varchar2 , ------存储过程定义中的全局变量声明时不可以声明变量的长度！！！
)
as
begin
phone:='0755-'||phone;
end;
-----------
declare
v_phone varchar2(20);
begin
v_phone:='86845931';
add_region(v_phone);
dbms_output.put_line('新的电话号码是：'||v_phone);
end;

Answer 1

add_region这个过程是未编译成功的，不成功的原因是 phone这个变量木有声明

Answer 2

create or replace procedure add_region
(
var_number in out varchar2 --不要封号
)
as
begin
var_number:='0755-'||var_number;
end;