Re: PL/SQL - I/O

Hi

robisonm_at_abcbs.com wrote:

> We are in the design phase of a project and we are looking at using the I/O
> feature in PL/SQL.
>
> We are looking for someone that has used this before
> and curious on the results. Likes?/Dislikes?
>

I assume you talk about the package UTL_FILE - I/O.

If so :

Limits :
 Lines read or written must not be longer than 1024 chars. This is the most awfull about it.
 You must set up each directory names in INIT.ORA in which you plan to access files.

Likes : very simple.
Dislikes : Not to be used for huge amounts of data, because of low performance.

               If think about writing or reading a table of some thenthousand rows each day go for C++ and ORACLES OCI.

Regards
 Robo.

Received on Fri Jun 26 1998 - 14:26:11 CDT