Re: Export Table To Flat File From Stored Procedure

You cannot start SQL*Plus from a stored procedure as far as i'm aware, the host command only works in SQL*Plus and Forms. You may want to consider external_procedures if you are using Oracle 8. You can get the external procedure to kick off SQL*Plus Apart from that, UTL_File may be the only way to go.

Mark

yitbsal_at_statcan.ca wrote in message <7ha3j9$itk$1_at_nnrp1.deja.com>...
>Hi,
>
>I need to export a table in a production environment (not a one-time
>job). As far as I know, there are two ways to do this:
>
>1. Write a SQL Plus script and invoke it from the stored procedure.
>2. Use the UTL_FILE package to output the table (one line at a time).
>
>Are there any other ways? Am I correct in assuming Method 1 is the
>fastest. How do I invoke a SQL Plus session from within a stored
>procedure?
>
>Thanks,
>Salaam Yitbarek
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Wed May 12 1999 - 02:57:10 CDT