Re: What is the difference between procedure and function?

From: Janek Metsallik <Janek.Metsallik_at_abs.ee>
Date: Tue, 22 Sep 1998 08:39:01 +0300
Message-ID: <36073856$0$170@diablo.uninet.ee>

Hi,

Actually, what is meant here is: Function can only be used as part of = another statement (IF, assignment, parameter of another call, SELECT = column, etc). Procedure must execute as a PL/SQL statement.

This is the difference between those two.

Purity is another topic.

Regards,
Janek.Metsallik_at_abs.ee

-------------------------------------------------------------------------=

suisum_at_freenet.edmonton.ab.ca wrote in message = <6tsjma$gcb$2_at_news.sas.ab.ca>...
I saw the following statement:

A procedure differ from a function is:

must execute as a PL/SQL statement.

Can anyone tell me what it means?

--
Best regards, Received on Tue Sep 22 1998 - 00:39:01 CDT