Solved

How do I create Web listener in Oracle 9i database (not in oracle 9iAS)?

Posted on 2004-04-28
1
484 Views
Last Modified: 2012-08-14
I am the beginer to the PSP(PLSQL Server Pages),I created a sample psp procedure "first"

<% page LANGUAGE="PL/SQL" %>
<% plsql PROCEDURE="first" %>
<HTML>
<HEAD><TITLE>This is a PSP Page </TITLE></HEAD>
<BODY>

This is a list of employees:<BR>
<% FOR emp IN (SELECT * FROM emp) %>
Employee ID = <%= emp.empno %>
Employee NAME = <%= emp.ename %> <BR>
<% END LOOP; %>
</BODY>
</HTML>

I have loaded this procedure into Database using loadpsp.
To access from the Internet explorer ,
I have to create PL/SQL Gateway through a Web Listener.
How do I create Web listener in Oracle 9i database (not in oracle 9iAS)?
0
Comment
Question by:rehman123
1 Comment
 
LVL 48

Accepted Solution

by:
schwertner earned 250 total points
ID: 10946386
Appache is installed on your computer as standart component of Oracle 9i installatio





What is MOD_PLSQL and what can one use it for?
MOD_PLSQL is an Apache module extention written by Oracle Corporation to render dynamic web pages from standard Oracle PL/SQL code. MOD_PLSQL was formerly called the Oracle PL/SQL Cartridge and OWA (Oracle Web Agent).
For more information about the Apache server, see the Oracle HTTP Server FAQ. More information about PL/SQL can be obtained from the PL/SQL FAQ.

+-CLIENT-+                +----------------S E R V E R--------------+
|        |                |                                         |
|   Web  | <--Internet--> | Oracle HTTP <-> mod_plsql <->  Oracle   |
| Browser|      HTTP      |   Server                      Database  |
|        |                |                                         |
+--------+                +-----------------------------------------+
·  Back to top of file
 
How does one start and stop MOD_PLSQL?
By default MOD_PLSQL is started when the Oracle HTTP Server is started.
·  Back to top of file
 
How does one configure MOD_PLSQL?
Start a Web Browser like Netscape Navigator and Internet Explorer and navigate to the MOD_PLSQL Gateway Configuration Menu (http://your.host.name:7777 and click on "mod_plsql"). Click on "Gateway Database Access Descriptor Settings". Select one of the options to add a new DAD (Database Access Descriptor). Enter at least the following fields:
·      Database Access Descriptor (DAD) Name
·      Schema Name
·      Oracle User Name
·      Oracle Password
·      Oracle Connect String (if not the local DB)
Click on "Apply" to make your changes permanent.
Configuration parameters and log files are stored in the $ORACLE_HOME/Apache/modplsql subdirectory.
·  Back to top of file
 
How does one program using MOD_PLSQL?
Standard Oracle PL/SQL programs can be extended to include MOD_PLSQL The Oracle Web Agent extends the Common Gateway Interface (CGI) to Oracle PL/SQL stored procedures. Programming is done in PL/SQL using the following set of packaged procedures:
o      HTP - Hypertext Procedures
o      HTF - Hypertext Functions
o      OWA_UTIL - Oracle Web Agent Utilities
o      OWA_COOKIE - Send end retrieve Web Browser Cookies
o      Etc.
Example PL/SQL procedure:
      CREATE OR REPLACE PROCEDURE HelloWorld AS
      BEGIN
            htp.htitle('My first dynamic Web page');
            htp.print('Hello world');
            htp.line;
      END HelloWorld;
      /
To run this example you would typically provide an URL like this to your Web Browser:
       http://your.host.name/pls/<DAD_NAME>/HelloWorld
·  Back to top of file
 
How does one use HTTP COOKIEs?
Cookies allow any site to store information on a WEB Browser's hard disk (cookie.txt file). This information is sent back to the originating site whenever you access it again.
Look at this code example:
      owa_util.mime_header ('text/html', FALSE);
      owa_cookie.send (cuid, xsession_id, sysdate+1);
      owa_util.http_header_close;
·  Back to top of file
 
Can a Web page be refreshed/reloaded after a given interval?
Yes, use the OWA_UTIL.REDIRECT_URL function. Alternitavely, look at the code example below:
      <HTML>
      <HEAD>
      <META HTTP-EQUIV="REFRESH" CONTENT="3; URL=any_valid_url">
      <TITLE>Stay tuned!  3 Seconds until relocation</TITLE>
      ...
      </HTML>
·  Back to top of file
 
Where can one get more info about MOD_PLSQL?
·      Download mod_owa - Open source Apache PL/SQL Gateway Module
·      The Unofficial Oracle Web/Application Server Site
·      OWSKiller - replace OWS with Java servlets for free
·      MOWI - WWW to Oracle Interface
·      SWOOP - WWW/ORACLE Connectivity Software
·      Oracle XML integration
·      WebAlchemy - tool for translating HTML to PL/SQL

Example:
After you create DAD as explained above named NIKI try:


Log using SQL*Plus in the schema for wich you have created the DAD NIKI:

CREATE OR REPLACE PROCEDURE L43 AS
      BEGIN
            htp.print('<HTML><HEAD><TITLE>Listing 4-3</TITLE></HEAD>');
            htp.print('<BODY>');
                htp.print('<FORM NAME="F1" ACTION="http://ms.com/asp/prc.asp" METHOD="GET">');
                htp.print('<TEXTAREA NAME="TA" COLS="40" ROWS="4" WRAP=soft">');
                htp.print('This text is inside TEXTAREA 1. Note how lines of code are  ');
                htp.print('automatically wrapped and how line breaks in the code cause breaks.');
                htp.print('</TEXTAREA>');
                htp.print('<BR>');
                htp.print('<TEXTAREA NAME="TA2" COLS="40" ROWS="4" WRAP=soft"> ');
                htp.print('This text is inside TEXTAREA 2. Note how lines of code are');
                htp.print('not automatically wrapped and how line breaks in the code cause breaks.');
                htp.print('</TEXTAREA>');
                htp.print('<BR><INPUT TYPE="submit">');
                htp.print('</FORM>');
                htp.print('</BODY>');
                htp.print('</HTML>');
      END L43;
/


http://<your computer name>:7778/pls/niki/L43
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question