Path: news.easynews.com!easynews!cyclone2.usenetserver.com!news.webusenet.com!fr.clara.net!heighliner.fr.clara.net!fr.colt.net!writer!not-for-mail
From: "s Lehaire" <s.lehaire@meilleuregestion.com>
Newsgroups: comp.databases.oracle.misc
Subject: Stupid question
Date: Thu, 8 Aug 2002 10:07:46 +0200
Organization: ImagiNET / Colt Internet
Lines: 24
Message-ID: <ait7sk$4no$1@reader1.imaginet.fr>
Reply-To: "s Lehaire" <s.lehaire@meilleuregestion.com>
NNTP-Posting-Host: host.161.39.23.62.rev.coltfrance.com
X-Trace: reader1.imaginet.fr 1028793044 4856 62.23.39.161 (8 Aug 2002 07:50:44 GMT)
X-Complaints-To: abuse@imaginet.fr
NNTP-Posting-Date: 8 Aug 2002 07:50:44 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: easynews comp.databases.oracle.misc:85308
X-Received-Date: Thu, 08 Aug 2002 00:59:00 MST (news.easynews.com)

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