Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

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



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.