Re: Examples of stored procedures

after creating the procedure, you may want to run it from SQL*Plus:

set serveroutput on
execute hello_world;

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:955128198.11792.4.pluto.d4ee154e_at_news.demon.nl...
> create or replace procedure hello_world is
> begin
> dbms_output.put_line('My first stored procedure');
> dbms_output.put_line('Hello world');
> end;
> /
>
>
> You are just asking for a Microsoft answer :)
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <jcho128_at_my-deja.com> wrote in message
 news:8cl0kc$snp$1_at_nnrp1.deja.com...
> > Does anyone have an example of any type of stored procedures
 in Oracle?
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri Apr 07 2000 - 00:00:00 CDT