Reg. Spooling files in SQL*PLUS

From: Arul kumar <rakumar_at_mahindrabt.com>
Date: Wed, 27 Dec 2000 10:16:55 +0530
Message-Id: <10722.125343@fatcity.com>

Hi Gurus,

We r using UTL_FILE package generating flat files from table data. It is doing a pretty good job. But the client is asking for simple scripts involving SPOOL command in SQL PLUS.

SPOOLing also does a good job but how to trap the error when something goes wrong like " Buffer Overflow" and all. Is there any mechanism to log the errors at SQL PLUS level ? Anybody tried ?

I would like to know how far it is efficient to go for SPOOLing data from Tables with millions of records.

TIA, Received on Tue Dec 26 2000 - 22:46:55 CST