Re: help with database app

Ed wrote:
> For my first web-driven application I have to use PL/SQL and Oracle
> database. I'm on my third re-write and still running into walls. This
> is a rather complex system utilitzing 6 pages of forms, with each page
> accessing two or three tables at a time. I need to be able to find,
> update, add, and scroll through records.
>
> Can anyone suggest an online resource with a rather simple example of
> this type of application that I could use as a model?

Ed, not sure what you're asking for. Is this a db design issue, SQL join issue, Oracle transaction (update/delete/insert) issue, mod_plsql issue, HTML rendering issue, creating interactive and dynamic web pages issue.. or something else?

Web development for Oracle - you should seriously consider using HTMLDB. It is a free companion product for Oracle 10G. It supports Oracle 9.2.

Installation is as simple as download the HTMLDB 1.6 zip, unzipping it and running the install SQL script with a couple of parameters using SQL*Plus.

Then you point your browser (via Apache mod_plsql) to the HTMLDB stored proc and you have a Microsoft Access type development interface to develop web-based Oracle PL/SQL systems. It is that simple.

--
Billy