Re: ORACLE WEB SERVER

From: Troy Cheramie <tcheram_at_entergy.com>
Date: 1997/02/28
Message-ID: <3317419e.365904052@netnews.prod.entergy.com>#1/1

Here's a simple one.
create or replace procedure hockey_pass (person in varchar2) is

n_assists integer;

     begin
                        select num_assists into n_assists
       from hockey_stats
     where name=person;

htp.print(person||' has '||to_char(n_assists)||' assists this season') end;

TroyC.

On Thu, 27 Feb 1997 19:18:25 GMT, Matthew Montebello <M.Montebello_at_cs.cf.ac.uk> wrote:

>Could anyone direct me to some html examples where the Oracle Web Server
>is used to make queries, updates etc.. to tables.
>
>Thanks.
>
>MAtt
>--
> _/ _// e-mail: m.montebello_at_cs.cf.ac.uk _/ _//
> _/_/_/_/ tel: (01222) 874000 ext 6071 mobile: 0370 741082 _/_/_/_/
> _/ _/ _/ URLs: http://www.cs.cf.ac.uk/User/M.Montebello _/ _/ _/
>_/ _/ http://www.geocities.com/SiliconValley/Park/2723/ _/ _/

Visit http://www.geocities.com/BourbonStreet/2481 for DBA Web App Topics

Received on Fri Feb 28 1997 - 00:00:00 CST