Re: HELP w/ PL/SQL writing to a flat file.

CyberSaurn (cybersaurn_at_aol.com) wrote:
: not work with any release less than 7.3. We are currently investigating
: creating an instance under 7.3 to house our PL/SQL and linking over to tables
: in a 7.2.3 instance until we get all our instances upgraded to 7.3. Anyone out
: there have any commentary on this approach?

How much data are you pulling out and why use PL/SQL ?

Using PL/SQL for text output to flat files is not exactly a pleasent experience, especially if there is a lot of formatting or massging required.

PERL5 has some very nice text formatting/handling capabilities and can access an Oracle v7 database with relative ease and efficiency via the DBI and DBD-  modules. PERL or any other such language may not be as portable as well written PL/SQL however.

Also the prospect of installing a 7.3 instance just to get access to one feature seems a trifle overkill to me. It may be that you plan to go 7.3 (and not 8.x) as the next upgrade so this may not be a big issue.

Just my 0.02

IAP

--
In an attempt to reduce junk email I use an invalid 'From' address.
My correct email address can be determined by replacing 'not.valid' with 
'value.net'