Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Wed, 1 Sep 2010 20:12:35 -0400
Message-ID: <AANLkTikOg425u2FgN6PCm9hwZ=_+kvK7NJwRkRG6CHM5_at_mail.gmail.com>
<snip>
So, is there any real advantage to using Pro*C over SQL*Plus to spool result sets to flat files? I certainly don't want to become a Pro*C expert, so any ideas would be greatly appreciated.
</snip>
Date: Wed, 1 Sep 2010 20:12:35 -0400
Message-ID: <AANLkTikOg425u2FgN6PCm9hwZ=_+kvK7NJwRkRG6CHM5_at_mail.gmail.com>
<snip>
So, is there any real advantage to using Pro*C over SQL*Plus to spool result sets to flat files? I certainly don't want to become a Pro*C expert, so any ideas would be greatly appreciated.
</snip>
If you are going to write from the RDBMS to the file system, you should also consider using external tables.
Here's an article that describes how to do that:
http://www.oracle-developer.net/display.php?id=325
-- Rumpi Gravenstein -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 01 2010 - 19:12:35 CDT