USAGE OF PIPELINED RETURNS INVALID DATATYPE

I have a package like this

CREATE OR REPLACE PACKAGE PAY_CN_VIEWS_PKG AS TYPE payment_methods_record IS RECORD(
assignment_action_id
pay_assignment_actions.assignment_action_id%TYPE );
TYPE payment_methods_tab IS TABLE OF payment_methods_record INDEX BY BINARY_INTEGER; FUNCTION pay_cn_arch_payment_methods RETURN payment_methods_tab PIPELINED; END PAY_CN_VIEWS_PKG; CREATE OR REPLACE PACKAGE BODY PAY_CN_VIEWS_PKG AS FUNCTION pay_cn_arch_payment_methods RETURN payment_methods_tab PIPELINED
IS

   CURSOR csr_viewdata1
   IS
     SELECT 1 assignment_action_id FROM DUAL;

  payment_method_rec payment_methods_record;   payments_table payment_methods_tab;

BEGIN   FOR csr_data IN csr_viewdata1
  LOOP
     payment_method_rec.assignment_action_id := csr_data.assignment_action_id;

     pipe row(payment_method_rec);
  END LOOP;   CLOSE csr_viewdata1;

END pay_cn_arch_payment_methods;

END PAY_CN_VIEWS_PKG; Now when I issue the following statement SELECT * FROM
table(PAY_CN_ARCH_PAYMENT_METHODS.payment_methods_table())

I get invalid datatype....
Can anyone help me in this to resolve the issue. Received on Wed Aug 10 2005 - 23:19:40 CDT