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
