Re: PL/SQL UTL_FILE output

On Sat, 19 Mar 2005 09:54:15 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>
>I'm just starting out with PL/SQL and would appreciate some advice. I've
>written a simple procedure to write some data out to a file. I would like
>the file to have fixed width fields, seperated by pipes. The data gets out
>to the file OK, but not fixed width. What can I do to correct that? Also,
>please point out my rookie mistakes.

If the original columns are varchar2 you would need to use RPAD everywhere to properly lineup your data. As you already have a separator, I'm not sure what compelling reason there is (other than to waste disk space), to do this.

Your sql statement is of course horrible. It is not formatted at all, and it uses hardcoded literals all over the place. Procedures and cursors have parameters. In your case you would probably create 1000 almost identical procedures, except for the hardcoded literals, and choke your CPU to death by doing so.

--
Sybrand Bakker, Senior Oracle DBA