Export Table To Flat File From Stored Procedure

From: <yitbsal_at_statcan.ca>
Date: Tue, 11 May 1999 20:23:07 GMT
Message-ID: <7ha3j9$itk$1_at_nnrp1.deja.com>


[Quoted] 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?

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 - 22:23:07 CEST

Original text of this message