Unable to pass varchar datatype as input parameter in my SQL function

Question

Unable to pass varchar2 datatype in my function. Below is my code:

create 
or replace function f1(i varchar2) return varchar is j varchar2(10);
begin
   select
      last_name into j 
   from
      employees 
   where
      first_name = 'I';
return j;
end
;
/

Select f1('Steven') from dual;

It is showing null value instead of returning the Name.

Acroyear · Accepted Answer · 2019-12-30 18:12:17Z

1

You need to reference your parameter without quotes in your where clause, not as 'I'.

create or replace function f1(i varchar2)
return varchar
is
j varchar2(10);
begin
select last_name
into j
from per_all_people_f
where first_name=i;
return j;
end;

edited Dec 30, 2019 at 18:12

answered Dec 30, 2019 at 18:05

Acroyear

1,4614 gold badges25 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to pass varchar datatype as input parameter in my SQL function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related