Re: WebServer 1.0 question

In previous article, Kelly Sharpe (ksharpe_at_ssf8.jsc.nasa.gov) wrote:
[QUOTE]"You can easily access Oracle7 with CGI. Any executable program or
[QUOTE]shell command file can act as a CGI executable. This includes
[QUOTE]applications developed with OCI, Pro*C, SQL*Module, SQL*Plus, Oracle
[QUOTE]Reports, and Oracle Graphics." -- Documentation on WebServer 1.0

[QUOTE]This is the only mention about WebServer's reuse of existing
[QUOTE]applications I can find. However, I can't find an example of how it's
[QUOTE]done. Has anyone tried using the WebServer to execute a SQL*Plus script
[QUOTE]and then making any spooled output available to the client browser?

      There is a very good example :

      It is the administration server homepage that you first access after setup and the registration of your WebServer.

      Indeed, whenever you create your first listener or create OWA_DBA service or create OWA_DEFAULT_SERVICE service, some executables are called. Moreover, whenever you grant the privileges to allow the access of htp, htf ..., some SQL*Plus scripts are called. You can see this script under $ORACLE_HOME/ows/admin.

--

                                                               Best Regards,

                                                                 Lun Wing San
                                                                 ­Û  ¥Ã   ·s


Email address : sunny_at_hkpc.org 
Telephone     : (852)2788 5841