Good point .. this is another difference between procedure and a function

When you create a function ,SQL server will allow you to call a procedure from the Function.

However when you execute the function , it will error out with the messgae "Only functions and extended stored procedures can be executed from within a function".

It means only extended stored procedures can be called from a function.