Re: What is the difference between procedure and function?

Yes you can, try this :

exec :myVar := fnMyFunction

The only difference is that an function return a value, a procedure does not.
Otherwise is there no difference about parameters and behaviour. And the reason that you can use a function it in a select statement is just because it return something.

/Ulf

bhogak_at_my-dejanews.com wrote in message <6u1jih$nmf$1_at_nnrp1.dejanews.com>...
>To run a proc, you type at the prompt:
>exec procname;
>You cannot run a function in the same way.
>-Kumar
>In article <6tsjma$gcb$2_at_news.sas.ab.ca>,
> 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,
>>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Sep 21 1998 - 05:20:09 CDT