Database Reference
In-Depth Information
rate computers, which makes this type of architecture portable, scalable,
and capable of connecting across the Internet with ease.
Here is an example of the HTML code to call our CDREPORT.SQL
script. You must change the hostname, port number, and database name to
suit your installation. The parts you must change are highlighted.
<HTML>
<HEAD><TITLE>CD Dynamic Report</TITLE></HEAD>
<BODY>
<H1>CD Dynamic Report</H1>
<H2>CDs with specified CD ID Numbers.</H2>
<FORM METHOD=get ACTION="http://
hostname
:7778/isqlplus">
<INPUT TYPE="hidden" NAME="userid" VALUE="music/music@
SID
">
<INPUT TYPE="hidden" NAME="script"
VALUE="http://
hostname
:7778/CDREPORT.SQL">
Enter the highest CD ID Number to report:
<INPUT TYPE="number" NAME="CDNUM" SIZE="4">
<INPUT TYPE="submit" VALUE="Run Report">
</FORM></BODY></HTML>
This HTML file, along with the script CDREPORT.SQL, should be
placed into the HTTP Server's document directory on the server. The
default document directory location is $ORACLE_HOME/Apache/
Apache/htdocs. Before copying the two files, remove the following line
from the CDREPORT.SQL file because iSQL*Plus does not allow the
ACCEPT command:
ACCEPT CDNUM PROMPT 'What CD number do you want to see? '
After copying the two files to the document directory on the HTTP
server machine, go to the browser on the client machine and enter the URL
for the HTML page, changing the hostname and the port number as
needed.
http://<hostname>:7778/cdreport.html
Figure 8.27 shows the result.
Typing an appropriate number into the box and clicking the Run
Report button produces a result as shown in Figure 8.28. The script is exe-
