Re: Option boxes and oracle

re: tough luck.
- Oracle does provide a pl/sql web toolkit which is composed of functions that html-enable pl-sql. This is accomplished in 2 ways, either using the built-in Oracle functions eg. htp.tablerowopen('bla arguments') or using a generic htp.print('standard htl tags embedded').

Executing the pl/sql code generates html code that can be called via the Oracle Application server or used as part of another page/program...

Note: there is also a tool called Webalchemy created by one of the developers who was part of the Oracle Application Server development, however I do not believe it is supported by Oracle...

Hope this helps...

Stephen Harris wrote:

> Martin Lynch (mlynch_at_bfsec.bt.co.uk) wrote:
>
> : Im writing pl/sql (oracle) to produce some html pages.
>
> Tough luck.
>
> : Ive got 3 tables each with a number of rows (around 8)
 

> : Can I have two option boxes (the first for the table names and the second
> : for the rows of that specific table) so that when i choose the table i want,
> : the
> : columns in the second are automatically and instantly shown in the second
> : option box.
>
> Not easily. Remember, the "clicking" of boxes is done at the client side
> (the web browser) and this has no connection to your database at all. So
> the only way of doing what you want is to download _ALL_ the information
> to the client initially and then use javascript processing on the client
> side to dynamically change the forms. Dynamically changing forms with
> javascript is a standard example. I'm sure there's a version on Netscape's
> site somewhere.
>
> If this is for an intranet then you may wish to consider java and JDBC
> connections into the database from the client directly. Don't do this
> for Internet apps :-)
>
> --
>
> rgds
> Stephen
Received on Sun Mar 21 1999 - 00:00:00 CET