| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: HOW DO I VIEW PLSQL STORED PROCEDURES ON A BROWSER?
You can give a try to our Dynamic PSP product which does just that - allows
you to develop web applications using PL/SQL right from your web browser.
Go to http://www.dpsp-yes.com for trial version and docs.
As of your specific question - read the documentation which comes with mod_plsql (if you installed Oracle HTTP server, verify that it runs by going to http://localhost:7777 and if you see the welcome page and links, then go to mod_plsql pages and click Help icon in the upper right corner - and there you will find complete docs on mod_plsql).
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Mustafa Yousofi" <mustafayousofi_at_hotmail.com> wrote in message news:b7677682.0202161815.5b23f1a8_at_posting.google.com...Received on Mon Feb 18 2002 - 13:26:34 CST
> 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.
![]() |
![]() |