Oracle Stored Procedure Error

* ERRORatline1: ORA-06550: line1, column7: PLS-00221: GET_SALisnotaprocedureorisundefinedORA-06550: line1, column7: PLSQL: Statementignored errors like this occur because the return is not assigned to one, so fyouwanttoexecuteafuncti

* 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 has an error like this because it is not assigned to one, so 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

An error similar to this occurs because the returned value is not assigned to a value.

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;