SINGLE ROW RETURN

lv_sql_str_prefix
 := 'BEGIN
  SELECT ' || pv_search_value || ' INTO retval FROM TGTRA05S
  WHERE 1=1 AND TRPR_ID = :pv_trpr_id AND TRPR_DEGR = :pv_trpr_degr ;
     END ;
     ';

    EXECUTE IMMEDIATE lv_sql_str_prefix USING OUT retval, IN pv_trpr_id , IN pv_trpr_degr;

SELECT count(*) into retval
      FROM TGTRA05S T05S, TGTRA26S T26S
     WHERE 1=1
       AND T05S.TRPR_ID = pv_trpr_id