Programming Exercise I Construction (Cont.)
  1. Calling a CGI Script (Linux Shell)
    2.  CGI (Common Gateway Interface) is a standard for running external programs from a World Wide Web HTTP server. CGI specifies how to pass arguments to the executing program as part of the HTTP request. It also defines a set of environment variables. Commonly, the program will generate some HTML pages which will be passed back to the browser. For the previous interface, the following CGI script ListCourses.cgi is activated once a button is clicked:

    ~/public_html/cgi-bin/demo/10/ListCourses.cgi
    view source
    print?
    1#!/usr/bin/bash
    2# To set up the Oracle environment dynamically
    3CLASSPATH=.:/usr/lib/oracle/23/client64
    4CLASSPATH=$CLASSPATH:/usr/lib/oracle/23/client64/lib/ojdbc8.jar
    5CLASSPATH=$CLASSPATH:/usr/lib/oracle/23/client64/lib/ottclasses.zip
    6export CLASSPATH
    7 
    8# Calling the CGI Perl script
    9/usr/bin/perl  ListCourses.pl

    These statements are the minimum, but they work so far. We may need to add more statements later if necessary. The last statement calls the CGI Perl script,     ListCourses.pl . Note that

    • “Internal Server Error” will be issued if the Perl script does not include either one of the following two commands: 
         print( "Content-type: text/html\n\n"  );
   print( "Content-type: text/plain\n\n" );
    • This script is for setting the environment variables for JDBC. If JDBC is not used in this function, you may skip this step.