Solved

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

Posted on 2004-04-28
1
491 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

739 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