String srecv1,srecv2,srecv3

srecv1 = 'Иванов Иван Иванович'
srecv2 = 'Он же Жора'
srecv3 = 'Он же Гоша'

select spx_selectaccar ( :srecv1 , :srecv2 , :srecv3)
INTO :ref
from DUAL;

CREATE OR REPLACE Procedure pr_you_really_must_see_it
       (dwresultset in out cyr_for_dw.curtype,as_you_string in CHAR)
   IS

BEGIN
    open dwresultset for
    --Ваш SELECT-----------------------------------
    SELECT (всякое)
     FROM (таблица)
   WHERE  таблица.это = as_you_string
----------------------------------------------------
   ;
    
END;