Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Website using Oracle (Shortened version)

Re: Website using Oracle (Shortened version)

From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 01 Feb 2003 18:11:27 +0100
Message-ID: <3E3BFFBF.5020303@netscape.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US