ExecuteScalar and Stored Function
392766Jul 25 2003 — edited Jul 28 2003Hi,
I am trying to execute a simple function through ExecuteScalar, but keep on getting an error that this is not a StoredProcedure.
What am I missing. I am not passing any parameters and also not setting any "RETURN_VALUE" param.
CREATE OR REPLACE FUNCTION GetEmpSal()
return number as
aSal number;
begin
select sal into aSal from devemp where empno=pEmpNo;
return aSal;
end;