Re: WOW Questions

Chunyi,
I am not an expert, but I have recently installed WOW myself so i will do my best.  

liou_at_synapse.bms.com (C. Liou) wrote :

>I am trying to display data in Oracle on a WWW page.
>I checked //www.oracle.com but did not find the answers I need.
 

>What I have now:
> WOW kit installed on the Unix server.
> HTML scripts.
> Package procedures to access oracle data(and to pass result to the page?.)
     

>My questions are:
>1. Should the package procedures be 'loaded' into the database, or should it
>sit in some file directory? How then are these procedures referenced in the
>HTML scripts?

Yes, load them. WOW came with scripts that create the functions and procedures. Also, any procedures which you make need to be stored in the database. Make sure that the appropriate users have privilege.

The form action tells Oracle what procedures to execute. Oracle has an example at
http://dozer-mci.us.oracle.com:8080/auto/

In this they use
<FORM METHOD="POST" ACTION="/cgi-bin/wow/auto.register"> where wow is a shell script that contains information about connecting to the databse and calls wowstub, auto is a package name and register is a procedure in the package body. I believe that the use of packages is optional, but it seems like a good idea.

There are other exaples in the WOW distribution which you should install and examine.

>2. Where is the link between the HTML page and the package >procedure? How
>does the HTML script know what procedure to execute and where >to find it?

See above.

>3. There are some 'htp.*' functions in the procedure. What >are they and where
>can I read more about those functions?

The 'htp.*' functions are utilities that make it easier for you to output HTML. For example, htp.bold puts a <B> at the beginning of the text you pass and a </B> at the end.

Read the script that creates the procedures for more information.

>4. How to specify 'ACTION' in the HTML script?

See above.

>5. From the HTML script, how to pass parameters to the package procedure?

This works the same way as any other form. There are some good form tutorials on the web, or examine the examples in the WOW distribution.

>6. Does 'wowstub' need any parameters?

Yes, wowstub needs the procedure you are calling and any paramters it needs. If done correctly, this is all taken care of by the web server and shell script that it calls which calls wowstub.

>Your help will be appreciated!
 

>---Chunyi

Good luck,
Steve

As always, all opinions are my own and not my employers, blah blah blah. Received on Tue Aug 22 1995 - 00:00:00 CEST