Re: Data Out of Oracle

Previous to version 7.3 the options for outputting to a file without coding an oci program is pretty much limited to the spool command from plsql. The good news is that it works pretty well. It can be run from a batch file, error message can be trapped and processes rolled back, and you can format the query  very extensively or even use some of the basic reporting capability to add trailer records. I have used this successfully for production data and though it is not perfect it does work. Verion 7.3 adds direct file i/o support via the dbms_file package. One could if they had the time and inclination write similar support via OCI and named pipes.

Good luck.

Bob
In article <BEH.533.0188F0B2_at_csd.uwm.edu>, BEH_at_csd.uwm.edu says...
>
>We are running Oracle 7.2 with procedural option. On a dec alpha - if that
 is
>relevant.
>I need to write out a record for delete, insert and update to send back to
 our
>mainframe to update our IMS database there.
>I am planning on writing triggers to capture this action.
>My question is how to get the data out of Oracle. Ideally I would like to do
Received on Thu Sep 19 1996 - 00:00:00 CEST