my pleasure !
"Mustafa Yousofi" <mustafayousofi_at_hotmail.com> wrote in message
news:b7677682.0202230132.1a754fc7_at_posting.google.com...
> 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 - 06:50:45 CST
