I want to use the return value of a function and want to manipulate it, how do i do
CREATE OR REPLACE FUNCTION test(p1 in varchar2, p2 in varchar2)
RETURN VARCHAR2 AS
result varchar2(100);
saleeid varchar2(100);
BEGIN
Begin
SELECT saleid INTO saleeid
FROM salesman
WHERE lower(name) = lower(sys_context('userenv','session_user'));
return saleeid;
end;
result := 'saleid=saleeid'; >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Saleeid returned from previous input has to be used here for manipulating. ITs not working.
return result;
END GET_GROUP_BY_ID;
/