Home » Infrastructure » Unix » Re: Return code from sqlldr
Re: Return code from sqlldr [message #97589] Thu, 29 August 2002 06:47
narender
Messages: 4
Registered: August 2002
Junior Member
Hi Vivek,
This is Narender. I have a question about sqlldr running from korn shell program. The shell looks like this
------------------filename.sh--------------
sqlldr parfile=filename.par
echo $?
-------------------------------------------
The filename.par will have all the information about the sqlldr file (control file, bad file, discard file, log file, username/ password of database) as shown
----------filename.par----------
DATA=filename.dat
USERID=ru/rv@A2CX
CONTROL=filename.ctl
LOG=filename.log
BAD=filename.bad
DISCARD=file.dsc
-----------------------
When i try to run the filename.sh from unix,
(1) If the password/username is change for the oracle db. It is prompting to enter username/password. I would like to avoid this. I want to see only the error message such as "ORA-01017: invalid username/password; logon denied". I dont want to see the prompt.

(1) I am getting the:
SQL*Loader: Release 8.1.6.0.0 - Production on Thu Aug 29 10:36:34 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Commit point reached - logical record count 8

How can i avoid this message from the screen. All i want is the success/ failed message.

(3) How can i catch the oracle error massages from the shell scripts.

Please help
Thanks
Narender
Previous Topic: Re: diff. oracle 8i / 9i
Next Topic: core with Oracle 8.1.7 on AIX 4.3.3
Goto Forum:
  


Current Time: Fri Mar 29 08:01:43 CDT 2024