PL/SQL (MOSC)

MOSC Banner

I want to use the return value of a function and want to manipulate it, how do i do

edited Jun 13, 2014 10:23AM in PL/SQL (MOSC) 6 commentsAnswered

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;

/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center