FOLLOW UP:
Thank You very much! This did it and everything runs smooooth. Once
again thank you! Please let me know if I can help you in anyway in the
future.
"koert54" <koert54_at_nospam.com> wrote in message news:<k%Lb8.147572$rt4.13557_at_afrodite.telenet-ops.be>...
> "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 Sat Feb 23 2002 - 03:32:57 CST
