时间:2021-07-01 10:21:17 帮助过:89人阅读
* 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
*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;