oracle - Cryptic error when attempting to create PL/SQL function -

oracle - Cryptic error when attempting to create PL/SQL function -

create or replace function supplier (tradename in drug.tradename%type) homecoming varchar2 returnstring varchar2(32767); begin returnstring := lpad('*',32767,'*'); select formula,pharname returnstring drug tradename=tradename; homecoming returnstring; end; /

when effort create function, says :

warning : function created compilation errors.

when execute "show err", :

line/col error -------- ----------------------------------------------------------------- 7/2 pl/sql: sql statement ignored 7/44 pl/sql: ora-00947: not plenty values

any help much appreciated!

ora-00947 "not plenty values"

is beingness raised on line 7:

select formula,pharname returnstring

you selecting 2 columns, provide 1 variable set them in.

you can either add together sec variable, or utilize kind of look concatenate values, e.g.:

select formula,pharname returnformula,returnpharname

or

select formula || pharname returnstring

oracle function plsql compiler-errors sqlplus