postgresql 9.5 - ERROR: syntax error at or near "SELECT" LINE 14: v_result := SELECT * FROM iis_e_ack_pkg.is_e_ack_confirm

Question

CREATE OR REPLACE FUNCTION iis_e_ack_pkg.is_e_ack_confirm ( vi_record_id text, vi_business_type text, vo_note_type INOUT text ) AS $body$
DECLARE

    v_result varchar(1) := 'N';
    v_note_type varchar(50) := '';
    v_ack_submit_date  varchar(50) := '';

BEGIN
    
    v_result := SELECT * FROM iis_e_ack_pkg.is_e_ack_confirm(vi_record_id, vi_business_type, vo_note_type, v_ack_submit_date) INTO STRICT vo_note_type, v_ack_submit_date;

    RETURN;

  EXCEPTION
    WHEN OTHERS THEN
      v_result := 'N';
      RETURN;
  END;

$body$
LANGUAGE PLPGSQL
;

question from:https://stackoverflow.com/questions/65839971/error-syntax-error-at-or-near-select-line-14-v-result-select-from-iis-e

Answer 1

Waitting for answers