Outputting a table/recordset to a csv

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 22 Oct 2002 10:36:54 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702D215D4@lnewton.leeds.lfs.co.uk>

Hi Aiden,

Oracle does create a spool file - at least it has done for me in all versions from 734 to 9iR2.
Having said that, I don't use SQLWorksheet, rather TOAD and SQLPlus. Maybe Worksheet is different - I know it (used to) let through 'broken' SQL which is why our site must test all scripts, however written, using SQLPLus because that is what our customers have.

I did a system upgrade to our application meny years ago on a customer site - the whole this was absolute pants. Scripts written with Worksheet (8.0.6 version) didn't run properly on SQLPlus - which through up errors. You can imagine what the customer thought of me and the company I work for - I've never been so embarrassed in all my life.

When I got back to base, I went absolutely f'ing ballistic with our development teams/managers/anyone else who was unlucky enough to be around at the time !
And I won !

:o)

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Aidan Whitehall [mailto:aidanwhitehall_at_fairbanks.co.uk] Posted At: Tuesday, October 22, 2002 10:02 AM Posted To: server
Conversation: Outputting a table/recordset to a csv Subject: Re: Outputting a table/recordset to a csv

[SNIP]
Thanks for all the info. The error message, BTW, was "not currently spooling". It didn't dawn on me for a bit that you had to create the .csv
file for it first ;-) ASA did both, so it didn't cross my mind that Oracle
wouldn't.

[SNIP]
Received on Tue Oct 22 2002 - 04:36:54 CDT