Re: Problem with ouptu files

Hi Nicola!

I don't know the specific of you task but I think that you have a cursor in which you process fields of SQL statement and then use UTL_FILE. The simpliest way is to create concatenated
string from the fields of your SQL statement and then pass it as the only paramenter into PUTF procedure. All paramenters have VARCHAR2 type, so you apparently can concatenate all fields like in: for c in (select * from test_table) loop

    s:=rpad(c.field1,10)||lpad(c.field2,10)||...etc.,etc. ;     ...
    putf(my_handle, format, s);
    ...
end loop;

Or, if you need some output as a report you can just use means that is provided by SQL*Plus. It is possible to create complex reports in this tool too.

Or use Oracle Reports.

Another options is to use DBMA_OUTPUT package.

Again, all depends on your needs.

Regards,
Andrew Velichko
Brainbench MVP for Oracle Developer 2000 http://www.brainbench.com

<nicola_at_my-deja.com> wrote in message news:92fteu$jpj$1_at_nnrp1.deja.com...
> Hi !!!
>
>
> I'm using the PUTF procedure of the UTL_FILE package of ORACLE 8i to
> export the content of a query to an output file.
>
> The problem is that it does work only up to 5 arguments (5 table
> fields).
>
> There is a way to put more fields in the output file?
>
> Thank you,
>
>
> Nicola
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 28 2000 - 22:04:14 CET