Output when using a procedure call

Hello,

I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine and work as expected.

But how to flush the data into excel or words ?

The only way I found is

/** extract of the pl/sql ***

FOR z IN 1 .. v_local_index - 1 loop

v_clob := v_clob || p_local_data.c1( i ) || ";" || p_local_data.c2( i ) || ";" || …. || chr(10); /*** … because there are a lot of columns !

end loop

OPEN :xdo_cursor FOR select v_clob from dual;

/***/

The ouput into excel shows all lines. But there is only one column per line and i need to convert manually the column to several columns (standard function into excel).