> -----Original Message-----
> From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
>
>
> I've just discovered this, never thought if it was possible or not.
> Just wanted to share it with you, so forgive me if you know
> it already.
> Procedure can contain other procedures:
This is true of an anonymous SQL block as well.
declare
x pls_integer ;
function square (n number) return number
is
begin
return n * n ;
end square ;
begin
x := square (2) ;
end ;
/
