Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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