CREATE OR REPLACE FUNCTION policyFun (pObject_type IN integer) RETURN TypePolicyList PIPELINED AS
BEGIN
  FOR i IN (SELECT 
                IO_policy_name,
                IO.POLICY_ID,
                IO.insr_type
                FROM insis_cnt_v1.policy IO
                where IO.insr_type = pObject_type ) LOOP
    PIPE ROW(TypePolicy(i.policy_name, i.policy_id, i.insr_type));
      END LOOP;
  RETURN;
END;

create or replace
type TypePolicy as object 
(
 POLICY_NAME varchar2(500),
 POLICY_ID number,
 POLICY_STATE number
);

create or replace
type TypePolicyList as table of TypePolicy;

SELECT 
                IO_policy_name,
                IO.POLICY_ID,
                IO.insr_type
                FROM insis_cnt_v1.policy IO

CREATE OR REPLACE FUNCTION policyFun (pObject_type IN integer) RETURN TypePolicyList PIPELINED AS
BEGIN
    FOR i IN 1 .. pObject_type LOOP
    PIPE ROW(typePolicy('Policy ' || i, i, 1101));   
  END LOOP;

  RETURN;
END;