Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news.alt.net!news.usenetgateway.com!not-for-mail From: PeterS Newsgroups: comp.databases.oracle.server Subject: Re: SQL loader Date: Tue, 15 Apr 2003 19:19:20 +0000 Organization: dBforums Lines: 22 Sender: PeterS Message-ID: <2770558.1050434360@dbforums.com> References: <2768447.1050401296@dbforums.com> User-Agent: dBforums X-Original-NNTP-Posting-Host: dbforums.com X-Original-Trace: 15 Apr 2003 15:25:29 -0400, dbforums.com X-Authenticated-User: paul Xref: core-easynews comp.databases.oracle.server:183540 X-Received-Date: Tue, 15 Apr 2003 12:25:14 MST (news.easynews.com) Originally posted by robinspa > I have written some code in VBA which formats data in excel, saves it > as a csv and then runs a batch file to load it into an oracle > database. My problem is I need to know when the loading process has > finished so I can continue the code after the load has finished. Is > there an easy way to do this? Hello, I've nver done it myself, but I think you can look for sqlldr exit codes: all rows load successfully - EX_SUCC all/some rows rejected - EX_WARN Take a look at Oracle8i/9i Utilities. Hope it helps. Peter S. -- Posted via http://dbforums.com