oracle存储过程出错

* ERROR at line 1: ORA-06550: line 1, column 7: PLS-00221: 'GET_SAL' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored 出现类这样的错误，是因为没有将返回赋给一个 ，因此 f you want to execute a functi

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00221: 'GET_SAL' is not a procedure or is undefined
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

出现类似这样的错误，是因为没有将返回值赋给一个值 ，因此

f you want to execute a function you have to collect the return value into a variable.

So you need to define a variable and execute function to return into the variable as below

and run it using the run Script option not the Run Statement option.

  variable ret varchar2  (  20  );  execute  :  ret  :=  check_login  (  dd  ,  dd  );  select  :  ret   from   dual   

Or if you do it from plsql

  declare    v_ret varchar2  (  100  );  begin  

  v_ret  :=  check_login  (  a  ,  b  );  end  ;   

查看更多关于oracle存储过程出错的详细内容...