Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Website using Oracle (Shortened version)
Norman Dunbar wrote:
> Morning,
>
> I needed to build a dynamic web site thing recently for an asset
> management system I wrote here at work. Nothing special, a simply
> enquiry system is all that it is.
>
> 1. Get the HTTP server working correctly.
> 2. Login to it and create a DAD for your database.
> 3. Write a procedure in the database and use the HTP.xxxx procedures and
> HTF.xxxx functions to create the HTML for the page (examples below)
> 4. Call the procedure from the web page as
> 'http://server/pls/dad_name/procedure_name'
> 5. Pray :o)
>
> If your top level procedure has parameters, then you can wrap the call
> to that proc in another web page which allows the user to select or
> enter parameters then call the procedure, or, call it and pass the
> parameters on the URL, as in
> 'http://server/pls/dad_name/procedure_name?ename=xxxxx' as with normal
> URLs and parameter passing.
>
>
>
>
<BIIIIG snip!>
how about:
create or replace procedure testhtml as
begin
htp.p('Hello World!');
end;
/
for starters?
Frank
PS Have been over this is detail beore - search archives...
Received on Sat Feb 01 2003 - 11:11:27 CST