Pipelined function fails with error ORA-06502 if it is having string of length greater than 4000

Hi All,

        We have created a pipelined function for or use in one of the report queries.

The sample code is pasted below.

create or replace
package  xx_pipelined_pkg as
type xx_rec is record (x_val varchar2(32767));
type xx_rec_tbl is table of xx_rec;
function get_data(i in number) return xx_rec_tbl pipelined;
end xx_pipelined_pkg;
/
CREATE OR REPLACE PACKAGE BODY xx_pipelined_pkg AS
g_xx_rec xx_rec;
function get_data(i in number)  return xx_rec_tbl pipelined Is
BEGIN
g_xx_rec.x_val:='I would consider that the *order* of a collection is inherently related to the way you access the