| How to Write Batch file for SQL Loader on Windows and capture errors [message #73625] |
Mon, 07 June 2004 11:21 |
Sachin
Messages: 52
Registered: May 2001
|
Member |
|
|
<PRE class=CE>Can anybody Please give Windows Version of Capturing errors in SQL Loader</PRE><PRE class=CE>Regards</PRE><PRE class=CE>
<PRE class=CE><A name=1005071>[/url]#!/bin/sh
<A name=1005072>[/url]sqlldr scott/tiger control=ulcase1.ctl log=ulcase1.log
<A name=1005073>[/url]retcode=`echo $?`
<A name=1005074>[/url]case "$retcode" in
<A name=1005075>[/url]0) echo "SQL*Loader execution successful" ;;
<A name=1005076>[/url]1) echo "SQL*Loader execution exited with EX_FAIL, see logfile" ;;
<A name=1005077>[/url]2) echo "SQL*Loader execution exited with EX_WARN, see logfile" ;;
<A name=1005078>[/url]3) echo "SQL*Loader execution encountered a fatal error" ;;
<A name=1005079>[/url]*) echo "unknown return code";;
<A name=1005080>[/url]esac
<A name=1007845>[/url]
</PRE></PRE>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
