SQL> CREATE OR REPLACE PACKAGE BODY PKG22 AS 
  2  
  3    FUNCTION GET_TAB11_PE (
  4      VSKF1 IN VARCHAR2,
  5        VSKF2 IN VARCHAR2,
  6        VSKF3 IN VARCHAR2,
  7        VLF1 IN NUMBER,
  8        VLF2 IN NUMBER
  9    ) RETURN T_PKG22_TAB11  IS
 10  
    str PKG22_TAB11 : = (null, null, null);
 11      T T_PKG22_TAB11 : = T_PKG22_TAB11(); 
 12  
 13    BEGIN
 14  
   for i in (SELECT DISTINCT SF1,SF2,SF3 
 16     FROM TAB11  WHERE
 17    SKF1=VSKF1
 18    AND SKF2=VSKF2
 19    AND SKF3=VSKF3
     AND LD >= VLF1 AND LD <= VLF2) loop
        str.SF1 := i.SF1;
      str.SF2 := i.SF2;
      str.SF3 := i.SF3;
      t.extend;
      t(t.last) := str;
    end loop;
 21    RETURN T;
 22    END GET_TAB11_PE;
 23  END PKG22;

CREATE OR REPLACE PACKAGE PKG22 AS

  TYPE PKG22_TAB11 IS RECORD(
    SF1 VARCHAR2(4),
    SF2 VARCHAR2(4),
    SF3 VARCHAR2(10));

  TYPE T_PKG22_TAB11 IS TABLE OF PKG22_TAB11;

  FUNCTION GET_TAB11_PE(VSKF1 IN VARCHAR2,
                        VSKF2 IN VARCHAR2,
                        VSKF3 IN VARCHAR2,
                        VLF1  IN NUMBER,
                        VLF2  IN NUMBER) RETURN T_PKG22_TAB11
    pipelined;

END PKG22;
/
CREATE OR REPLACE PACKAGE BODY PKG22 AS

  FUNCTION GET_TAB11_PE(VSKF1 IN VARCHAR2,
                        VSKF2 IN VARCHAR2,
                        VSKF3 IN VARCHAR2,
                        VLF1  IN NUMBER,
                        VLF2  IN NUMBER) RETURN T_PKG22_TAB11
    pipelined IS
  
  BEGIN
    for i in (SELECT DISTINCT SF1,SF2,SF3 BULK COLLECT INTO T
     FROM TAB11  WHERE
   SKF1=VSKF1
   AND SKF2=VSKF2
    AND SKF3=VSKF3
  AND LD >= VLF1 AND LD <= VLF2) loop
      pipe row(i);
    end loop;
  END GET_TAB11_PE;
END PKG22;

for i in (SELECT DISTINCT SF1,SF2,SF3 BULK COLLECT INTO T
     FROM TAB11  WHERE
   SKF1=VSKF1
   AND SKF2=VSKF2
    AND SKF3=VSKF3
  AND LD >= VLF1 AND LD <= VLF2) loop