Re: What is the difference between procedure and function?

From: Helmut Hahn <helmut.hahn_at_bitoek.uni-bayreuth.de>
Date: Fri, 18 Sep 1998 14:10:56 +0200
Message-ID: <36024DCF.A2F5FBC5@bitoek.uni-bayreuth.de>

suisum_at_freenet.edmonton.ab.ca wrote:

> 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,

A function you can use in a SQL-Statement like

select YouFunc(ID) from dual;
That means that you can include the function call in a view or in a query of your frontend-tool:

create view test as
select ID,YourFunc(ID) from YourTable;

With procedures things are different.

Hope this helps
Helmut Received on Fri Sep 18 1998 - 07:10:56 CDT