IBE: Starting restore. Current time: 13:28:59
IBE: Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
     Error while parsing procedure MEK_DUBL.INSUR_CASE_BY_FIOD_KS's BLR.
     index SLUCH_IDX_FIOD cannot be used in the specified plan.
     there is no index SLUCH_IDX_FIO_P_DR for table SLUCH.
     Exiting before completion due to errors.
IBE: Restore completed. Current time: 13:29:09. Elapsed time: 00:00:10

procedure INSUR_CASE_BY_FIOD_KS(
    lpu_src varchar(6),date_1_src date,date_2_src date,prvs_src smallint,
    fam varchar(40),im varchar(40),ot varchar(40),dr date,
    novor_src varchar(10),fam_p varchar(40),im_p varchar(40),ot_p varchar(40))
  returns (
    case_id bigint)
as
begin
  
  for select s.case_id
        from sluch s
        where (
               not sluch_is_novor(:novor_src) and
               s.fam=:fam and s.im=:im and s.ot=:ot and s.dr=:dr and
               s.date_1=:date_1_src and s.date_2=:date_2_src and
               s.file_mp=1 and s.vid_mp=3 and s.lpu=:lpu_src and s.prvs=:prvs_src
              )
              or
              (
               sluch_is_novor(:novor_src) and
               s.fam_p=:fam_p and s.im_p=:im_p and s.ot_p=:ot_p and s.dr=:dr and
               s.date_1=:date_1_src and s.date_2=:date_2_src and
               s.file_mp=1 and s.vid_mp=3 and s.lpu=:lpu_src and s.prvs=:prvs_src
             )
        plan (s index (sluch_idx_fiod,sluch_idx_fio_p_dr))
        order by s.sluch_id asc
        fetch first 1 row only
  into case_id
  do suspend;

end

ALTER TABLE SLUCH ADD CONSTRAINT PK_SLUCH PRIMARY KEY (SLUCH_ID);

CREATE INDEX SLUCH_IDX_FIOD ON SLUCH (FAM, IM, OT, DR, DATE_1, DATE_2, FILE_MP, VID_MP, LPU, PRVS);
CREATE INDEX SLUCH_IDX_FIO_P_DR ON SLUCH (FAM_P, IM_P, OT_P, DR, DATE_1, DATE_2, FILE_MP, VID_MP, LPU, PRVS );

CREATE INDEX SLUCH_IDX_CASE_ID ON SLUCH (CASE_ID);
CREATE INDEX SLUCH_IDX_DATE_1_2 ON SLUCH (DATE_1, DATE_2);
CREATE INDEX SLUCH_IDX_FILE_VID_MP ON SLUCH (FILE_MP, VID_MP);
CREATE INDEX SLUCH_IDX_LPU ON SLUCH (LPU);

...

PLAN (S ORDER PK_SLUCH INDEX (SLUCH_IDX_FIOD, SLUCH_IDX_FIO_P_DR))