SQL*Loader return code?
From: Jeremy Wong <jewong_at_po.pacific.net.sg>
Date: 1997/03/18
Message-ID: <01bc33b7$73132ec0$0d7018d2_at_jem-s>#1/1
Date: 1997/03/18
Message-ID: <01bc33b7$73132ec0$0d7018d2_at_jem-s>#1/1
I'm trying to invoke SQL*LOADER from WIN NT command line to populate about 40 large tables in Oracle (via a OS batch file). I need to trigger off another stored procedure only after the data load completes. My problem is I DON'T KNOW WHEN SQL*LOADER FINISHES LOADING ALL THE TABLES. I need to know this to start store procedure.
How do I work around this problem? Does SQL*LOADER return some form of return code and how do I capture this?
Any help is appreciated.
Jeremy Received on Tue Mar 18 1997 - 00:00:00 CET