Error Handling between SQL*Plus, PL/SQL and OS?

From: gdas <gdas1_at_yahoo.com>
Date: 10 Jan 2002 21:16:36 -0800
Message-ID: <7a4ed455.0201102116.58ca0f8@posting.google.com>

Hi,

I'm running 8.1.6 on Windows.

I'm trying to dynamically archive or trim the last x months data off of a table, export it out to a file with a dynamically constructed name and then purge the data from the original table.

I've got a script that works. I use PL/SQL and SQL*PLus to spool out a dynamically generated PARFILE. A batch file then runs and does the export.

The part I'm not sure about is error handling. Right now, if the export fails for whatever reason, the last batch file which launches sql plus, connects and purges the data will still run.

I'd appreciate if anyone might be able to share any tips on how I might be able to communicate the success or failure of the export (either at the OS level or in the database) to the third batch file I have which purges the data.

Thanks in advance

Gavin Received on Thu Jan 10 2002 - 23:16:36 CST