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.com) 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.