Export Table To Flat File From Stored Procedure

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 Tue May 11 1999 - 15:23:07 CDT