I never seen things this way.

1. how is sqlplus getting $USRPWD?
2. What SQLCOMMAND starts with cat.

To send a script as a parameter you would call

SQLPLUS $USRPWD @norway.sql
Or sqlplus schema/[Email Address Removed] @norway.sql

Or loginto sqlplus and send the commands directly there until <<EOF and
skip Norway.

You might want to use the -s switch when calling sqlplus


-----Original Message-----
From: Choudhry Deepak
[mailto:oracledba-ezmlmshield-x17085836.[Email address protected]
Sent: Thursday, April 07, 2005 8:14 AM
To: LazyDBA Discussion
Subject: Need Help

Hi Gurus,

I need help


I just want to know when the below Error Comes


Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= - | -? | [ [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / |
/NOLOG
<start> ::= @<filename>[.<ext>] [<parameter> ...]
"-" displays the usage syntax
"-?" displays the SQL*Plus version banner
"-M <o>" uses HTML markup options <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode


I have been getting this error while connecting to database.

# USRPWD used by unloadto and plsql
export USRPWD="$DBSCHEMA/$[Email Address Removed] "USRPWD = $USRPWD"

DATE=`date +%Y%m%d`
SQLCOMMAND= `cat Norway.sql`
echo "$SQLCOMMAND"

unloadto output.txt <<END
$SQLCOMMAND
END


This is the Script which is failing because of SQLPLUS


Thanks and Regards
Deepak Choudhary



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page