ORA-06530 - Uninitialized composite on dbms_fetch for pipelined table function

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Shirish Joshi

    #1

    ORA-06530 - Uninitialized composite on dbms_fetch for pipelined table function

    Hi,
    This is the situation I have

    1. Return a PIPE_ROW from a PIPELINED function (f)
    2. In the main function, I form a query string that contains SELECT
    .... FROM TABLE(f(params) ). The query string is passed to dump_csv
    (from asktom.oracle.c om) to get the results into a flat file.
    3. The function dump_csv fails at dbms_fetch with the error ORA-06530.

    Has anyone faced such a problem ?

    Thanks,
    Shirish
    PS: I am using 9.2.0.4 on Win2K. And I am not using any LONG RAW etc.
Working...