Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!opentransit.net!proxad.net!proxad.net!nerim.net!zoy.org!deine.net!intgwpad.nntp.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail
Message-ID: <3D5225C2.D497F687@oracle.com>
From: Richard Foote <Richard.Foote@oracle.com>
Organization: Oracle Corporation
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: Stupid question
References: <ait7sk$4no$1@reader1.imaginet.fr>
Content-Type: multipart/mixed;
 boundary="------------AFD239489E22232DF00C41FF"
Lines: 58
Date: Thu, 08 Aug 2002 18:03:14 +1000
NNTP-Posting-Host: 144.139.227.235
X-Trace: newsfeeds.bigpond.com 1028793690 144.139.227.235 (Thu, 08 Aug 2002 18:01:30 EST)
NNTP-Posting-Date: Thu, 08 Aug 2002 18:01:30 EST
Xref: easynews comp.databases.oracle.misc:85309
X-Received-Date: Thu, 08 Aug 2002 01:06:02 MST (news.easynews.com)
--------------AFD239489E22232DF00C41FF
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi There,

Whichever is the standard method in your organisation.

It makes no difference otherwise.

Regards

Richard

s Lehaire wrote:
> 
> Hi,
> In PL/SQL what is the difference between IS an AS in a declaration of a
> procedure.
> When I create a procedure (under visual c++) the procedure is define like
> this :
> CREATE /*OR REPLACE*/ PROCEDURE /*PROCEDURE_NAME*/
> AS
> BEGIN
>  RETURN;
> END;
> 
> but when I read a book the declaration is :
> PROCEDURE Ze_procedure
> IS
>     declaration
> BEGIN
>     blahblah
> EXCEPTION
>     blahblah
> END;
> 
> so what is the best way to declare my procedure in Oracle 9i
--------------AFD239489E22232DF00C41FF
Content-Type: text/x-vcard; charset=UTF-8;
 name="Richard.Foote.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Richard Foote
Content-Disposition: attachment;
 filename="Richard.Foote.vcf"

begin:vcard 
n:;Richard
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:Richard.Foote@oracle.com
fn:Richard Foote
end:vcard

--------------AFD239489E22232DF00C41FF--