Hi Gurus ,

I am facing a problem

I don't know what am I doing wrong

Here is the Script


#!/usr/bin/ksh


#Get Databasename


DBCONNECT='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=C360-
DW-DBPRO
.CCE.CPQCORP.NET)(PORT=1521)))(CONNECT_DATA=(SID=DWPRO)))'
# Get db schema
DBSCHEMA=vouille
# Get schema password
#DBPASSWORD=pascal
DBPASSWORD=yhnji90


ORACLE_SID=DWPRO

#export ORACLE_HOME=/crm/oracle/$ORACLE_SID/817
#export ORACLE_HOME=/crm/oracle/STGDEV/817
export ORACLE_HOME=/crm/oracle/WWFDEV/817
export PATH=$ORACLE_HOME/bin:/usr/lib:$PATH:.
export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib:$SHLIB_PATH:.

# Set NLS_LANG variable
export NLS_LANG=American_America.utf8
echo "NLS_LANG = $NLS_LANG"

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

#DATE=`date +%Y%m%d`
#for i in AT BE CZ DK FI FR GE GR HU IL IT NE NO PL PT SA SP SW SZ TR UK

#do
#echo $i
#sed "s/country/$i/g" country_age.sql > country_age_tmp.sql
/crm/oracle/WWFDEV/817/bin/sqlplus $USRPWD
@/home/cdeepak/perlsrc/Norway.sql

#done



The problem is happening while connecting to oracle and executiog the
script Norway.sql(Bold and Marked In Red)


Please help me solving the Problem .


Thanks in Advance

Deepak Choudhary


Oracle LazyDBA home page