Forum OpenACS Q&A: Re: Difference between PL/SQL Procedure and PL/SQL Function

Collapse
3: Re: Difference between PL/SQL Procedure and PL/SQL Function (response to 1)
Posted by Don Baccus on 07/19/04 09:56 PM
Postgres is just as picky, it just doesn't have procedures, only functions :)

That's because there's no procedureal language "mode" in Postgresql (when you say "declare" or "begin" in SQL*Plus it invokes the PL/SQL compiler, rather than the SQL processor).  In Postgres there's only the SQL processor, and the "hook" into programmatic languages is the functional call.

Collapse
4: Re: Re: Difference between PL/SQL Procedure and PL/SQL Function (response to 3)
Posted by nithin sudhakar keyyoor on 07/06/06 11:06 AM
function should contain a return clause and it returns a value, where as procedure may return a value or it may not return a value