Re: Newbie - Creating Stored Procedures???
From: Ronald <rma_at_hawaii.edu>
Date: Fri, 10 Jan 2003 23:45:29 +0800
Message-ID: <3e1eea99$1_at_shknews01>
Date: Fri, 10 Jan 2003 23:45:29 +0800
Message-ID: <3e1eea99$1_at_shknews01>
Thank you very much for your support.
"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
news:cAjT9.1188$Ts4.74770633_at_newssvr21.news.prodigy.com...
> Ronald wrote:
> > Hello all, can someone please explain to me how to create stored
procedures
> > in Oracle8i? thanks a lot.
> >
> >
> Login to sqlplus as the schema owner and type:
>
> create or replace some_procedure (arguments) is
> ...[declare variables]...
> begin
> ...[write pl/sql code]...
> exception
> ...[handle errors]...
> end some_procedure;
>
> If it compiles, you've got a stored procedure. If it doesn't, start
> debugging.
>
Received on Fri Jan 10 2003 - 16:45:29 CET