Re: Newbie - Creating Stored Procedures???
From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 09 Jan 2003 18:55:04 GMT
Message-ID: <cAjT9.1188$Ts4.74770633_at_newssvr21.news.prodigy.com>
Date: Thu, 09 Jan 2003 18:55:04 GMT
Message-ID: <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:
[Quoted] 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 Thu Jan 09 2003 - 19:55:04 CET