Hi

I am trying to run a SQL statement from a unix script determined at runtime.
It is throwing me an error. Please advise some solution to this.

echo "Enter username for the database"
read username

echo "Enter password for the database"
read password

echo "Enter SQL stmt"
read sqlstatement

sqlplus ${username}/${password} <<EOF

spool output.lst;

execute immediate '$sqlstatement';

spool off;
EOF

try this

sqlplus -s <LOGIN>/<password>@$DBCONN <<-END > <DESTINATIONDIR>/<FLNAME>
set serveroutput on;
set head off;
set feed off;
set timing off;
set pages 0;
set line 200
<QUERY>
EXIT;
END

good luk

Regards,
Pankaj

sqlplus -s <LOGIN>/<password>@<DBCONN> <<-END > <DESTINATIONDIR>/<FLNAME>

Pankaj, if the query is known to me before running the script, then there is no issue but what if the user is inputting the SQL query to be run at the Run time of the Unix Script ?

if user need wants to run the query then everything shud be configurable
QUERY,PASSWRD,USENAME,DBCONN etc

i'm giving a sample of configuration file from which u'll have to extract the values and 'll have to proceed

XYZ
XYZ.db=ORACLE
XYZ.Configuration
XYZ.Dbconn=abcXYZ.Login=scott
XYZ.Pass=wljhu
XYZ.Query=SELECT RECORDSEQNUMBER||'|'||CALLIDNUMBER||'|'||RELATEDCALLIDNUMBER||'|'||DATEFORSTARTOFCHARGE||'|'||TIMEFO RSTARTOFCHARGE||'|'||ERRORTYPE||'|'||DATA||'|'||REGION||'|'||SWITCHID||'|'||FILENAME||'|'||DATEOFSUS PENSE||'|'||TIMEOFSUSPENSE||'|'||REPROSTATUS||'|'||ORIGEN_ERROR FROM E1_SUSPENSE;
XYZ.DstDir=/path od destination dir
XYZ.FileName=MM1_E1_SUS.txt

from the configuration file u have to fetch value like this way

QUERY=`grep -w <DBCODE>.Query <Full Path where the configuration file has been placed>/<Name of the configuration file>| cut -f2 -d"="`

good luk

Regards,
Pankaj