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