ORA-06530 - Uninitialized composite on dbms_fetch for pipelined table function
From: Shirish Joshi <joshirish_at_hotmail.com>
Date: 28 Nov 2003 09:49:44 -0800
Message-ID: <284913f2.0311280949.584c2fd9_at_posting.google.com>
Date: 28 Nov 2003 09:49:44 -0800
Message-ID: <284913f2.0311280949.584c2fd9_at_posting.google.com>
Hi,
This is the situation I have
- Return a PIPE_ROW from a PIPELINED function (f)
- 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.
- 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.
Received on Fri Nov 28 2003 - 18:49:44 CET