Re: Help!! Web Application Devl.
Date: 1997/05/08
Message-ID: <3372f1aa.8832800_at_newshost.us.oracle.com>#1/1
On 7 May 1997 18:51:41 GMT, kittu_at_Hawaii.Edu (Chakravarthy KM Nalamotu) wrote:
>I have a database designed and in place. I am using
>Oracle Web Server to create the application. I need to
>develop a web application. I created few sample PL/SQL
>procedures using OWA_UTIL.tablePrint etc.
>Now, where do I go from here. This is a typical
>application where the users enter data and generate
>some reports, not very complex. Could be a piece of
>cake deal using Forms or Power Builder.
>How do I proceed. Any available documentation?
>Your input would be greatly appreciated.
>Thanks,
> Kittu.
From the Admin port for your Oracle WebServer (usually 9999 on NT, 8888 elsewhere), you will links which will let you:
- Administer the WebServer through the WebServer Manager;
- View the online documentation;
- "Take the Train" demonstration application.
I would strongly encourage you to take a look at and dissect the "Take the Train" demo, as it employs examples of database authentication, form input, etc. ...basically a lot of the things you want to do.
With that said, it sounds like all you might need would be to define a DCD (Database Connection Descriptor) which provides the PL/SQL Agent with information, such as which Oracle database and Oracle user to connect to, in order to process requests. Once you do that, you will be able to directly call the stored procedures you have created which dynamically generate your HTML output.
Good luck!
Thanks!
Joel
Joel R. Kallman Enabling the Information Age through Oracle Government Network Computing! Bethesda, MD http://govt.us.oracle.com jkallman_at_us.oracle.com http://www.oracle.com
The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Thu May 08 1997 - 00:00:00 CEST