The other option, and one that will run much faster, is to write a Pro*C
program (or Pro*COBOL, if you're a quiche-eater). You can embed SQL and
PL/SQL in a C program and write the flat file using the features of C.
If C or COBOL are not your forte, Delphi or VB can also work as well.
-djc
> I was recently flabbergasted to discover that until Oracle 7.3, there is
no
> capability to do this (::scratching head in amazement::). One might
kludge
> around with DBMS_OUTPUT (max 1,000,000 characters per procedure I
believe) or
> other kludges, but they are that -- kludges -- and not very sustainable
over
> the long haul. UTL_FILE, mentioned in the previous response seems the
way to
> go.
Received on Wed Nov 12 1997 - 00:00:00 CST
