Re: HOW DO I VIEW PLSQL STORED PROCEDURES ON A BROWSER?

"Mustafa Yousofi" <mustafayousofi_at_hotmail.com> wrote in message news:b7677682.0202161815.5b23f1a8_at_posting.google.com...
> Bricklen <bricklen_at_shaw.ca> wrote in message
news:<3C6E5695.F1B1618_at_shaw.ca>...
> > Only thing that I can think of off-hand is to DESC the procedure (or
> > find it's contents by selecting from user_source) and spool that into a
> > text file, either with an html extension, or to be converted by your
> > favourite WYSIWYG editor into html for your viewing pleasure.
> >
> > Mustafa Yousofi wrote:
> > >
> > > I am new to Oracle(I know how to use SQL and PL/SQL) and I would like
> > > to know how I can view stored PL/SQL procedures on a web browser(IE,
> > > Netscape). Someone please help me!
>
> Follow Up:
> What I am planning to do is write PL/SQL packages that will contain my
> HTML(I will use htp.p(); to display the HTML). But Once that package
> is compiled successfully I would like to view it on the browser. I
> don't know how to spool the contents into a text file. I have seen
> many websites use pl/sql packages to run their whole
> website(http://www.verizonwireless.com/index.html, click on shop).
> From what I understood I need to set up a webserver which I already
> have(Oracle HTTP server which is using Apache 1.3.12), to view the
> package contents I type http://domain_name:port/? That is how far I
> have got on this.

You'll need an webserver with the plsqlmod and create a DAD (database access descriptor)
If you have installed the Apache webserver that comes with Oracle 8.1.7 then you
should be fine.
By default the webserver is configured to bind on socket 'yourhostname:7777' but
you can change this in $ORACLE_HOME/Apache/Apache/conf/httpd.conf Anyway - if you can get on http://yourhostname:7777/ you should see the standard
webpage that comes with it - it looks like this :

Oracle HTTP Server
Components
Apache
JServ
(demo)
Oracle JSP
(demos)
mod_ssl
OpenSSL
mod_perl
mod_plsql
BC4J
XDK
mod_ose

Near the bottom you'll see mod_plsql -> click on that You're now in the gateway configuration menu. Choose gateway database access description Choose add default

1. fill in a <DAD> name (doesn't matter what but it's a suffix in the url)
2. fill in your schema name
3. fill in the database connectivity info ( connect string etc)
4. choose a authentication mode (SSO, basic etc)

This should be enough to get you going ...

Now you surf to
http://yourhostname:7777/pls/yourDADname/yourprocedurename?arguments And you should now see the output of your procedure, function whatever ... Received on Sun Feb 17 2002 - 04:56:16 CST