Re: [HACKERS] SQL procedures

Simon Riggs wrote:
> It would seem to be implied by the SQLStandard that Functions and
> Procedures occupy the same namespace, since they are both Routines.
> 
> I can't see any benefit from having foo() function AND foo() procedure
> at same time. It would certainly confuse most people that come from
> programming languages without that distinction, but maybe someone
> knows some Oracle-foo that I don't?

The question already has been decided on the (better) basis of
the SQL standard, but for what it is worth:

Oracle has functions and procedures in the same name space.

Yours,
Laurenz Albe