#!/bin/sh
#
#  This is a real hack to pass fixed SQL to the server on oracle 7.
#
#
ORACLE_HOME=/usr/local/oracle7
ORACLE_SID=TPCDa1
export ORACLE_HOME
export ORACLE_SID
echo Content-type: text/html
echo
if [$# = 0 ]
then
echo "This should not have happened "

else
echo "<title> Output from SQL </title>"
echo "<pre>"
/usr/local/oracle7/bin/sqldba mode=line << !
connect tpcd/tpcd@T:harrier-nc.npac.syr.edu:TPCDb
select * from suppliers where rownum <= 100;
exit
!
echo "</pre>"
fi

