Re: web access to oracle 7 database

Its been a while since I set my webserver, but I believe the major steps are:

1. Create a web listener first from the admin port, (you can do this from the browser) on a port of your choice say port 80.
2. Oracle webserver's configuration allows you to map directories and url's to the second port. You may go to your file system, create a directory, put a html file called index.html and map the server virtual paths to it. HTML file mapping is simple. You should be able to pretty much do everything from the browser interface.
3. To configure the PL/SQL agent you will have to create a data connect descriptor (DCD) it is of the owa_<dcdname>/owa/<pl/sql stored procedure name>.

i.e http://myserver:80/owa_X/owa/Y where X = dcd name, Y = pl/sql procedure name.

During this process, you will have to map it to a user's schema, you can also install
the PL/SQL samples and kit in that user's schema.

If you have a schema browsing tool, look at the schema of the userid to which the admin listener
is mapped, you will be able to see the stored procedures there.

4. SQL statements are not kept anywhere but in PL/SQL procedures.

5. Your SQL programmer should use a PL/SQL tool such as Oracle's Procedure Builder (yuck!!)
or third party slick tools such as SQL Navigator etc...

When the admin listener is created and PL/SQL samples installed, they are installed in a
user's schema. If you can get permission from that user, you can change the PL/SQL

Hope that works for you, Pity with such a neat product, Oracle could have provided better
documentation...:)

Raman Batra, Oracle DBA

whitp_at_ci.winston-salem.nc.us wrote:
>
> I have Oracle web server 2.1 up and talking to an Oracle 7 database on the
> same machine. The sample apps work (only from the from the admin port).
> We have our own table with data that we can 'browse' (with Netscape from
> the network) through the admin listener port using the 'browse database'
> option. I can't seem to get anything working from the second web listener
> created during install. What are the steps I need to take to create our
> own front end that can see this data when a web user requests it?
> Specifically: Where do I put my HTML files? I don't want to overwrite
> the index.html file that is already in ows21/doc/ since this is the server
> admin file. Should I create a new directory and remap the listener to it?
> How do I call procedures from the html file that will access the
> database? Are the SQL statements kept in the database or a separate file,
> and if so what directory do these go in? Our SQL programmer has tried
> modifying the sample apps but the system won't let him save anything. How
> do I change permissions to allow us to create and save files? Also is
> there a way around having to specify the port number in the URL of an html
> request? How do you access the webserver developers toolkit? The docs
> metion a 'web agent' but I see nothing but a pl/sql agent in the server
> admin page. I assume the docs are outdated. I have read the CD docs from
> front to back but I need an example or outline of one application to put
> this whole process in perspective. Any reading material you could suggest
> would also be helpful.
> Thanks,
> Whit Pitcher
> Intranet programmer
> City of Winston-Salem, NC
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
  Received on Wed Jun 18 1997 - 00:00:00 CDT