我创建了一个存储过程,而且创建成功,但是我调用存储过程的时候不成功,希望你们帮我解决
创建存储过程
Create Or replace procedure pro_selectAll (a Out Numeric)
As
Begin
Select m Into a From employee Where Id=1;
End;
调用存储过程:Execute pro_selectAll;
创建存储过程
Create Or replace procedure pro_selectAll (a Out Numeric)
As
Begin
Select m Into a From employee Where Id=1;
End;
调用存储过程:Execute pro_selectAll;
2 As
3 Begin
4 Select deptno Into a From emp Where empno=7369;
5
6 End;
7 /
Procedure created
SQL> set serveroutput on
SQL> var v_a number
SQL> execute pro_selectAll(:v_a);
PL/SQL procedure successfully completed
v_a
---------
20
SQL>
但是你没有变量接收啊
declare
v_a employee.m%type;
begin
pro_selectAll(v_a);
dbms_output.put_line(v_a);
end;
调用有问题 对于含参数的问题 不汉参数则可以向你这样直接来var a number;exec pro_selectAll(:a);print :a或者用匿名块