Implementing object methods as procedures

Is there any reason one would want to implement an object method as a procedure rather than as function?

It's easy to use a function, because it returns a value, so you can use it in a select, in a where clause, etc.:

  SELECT T.MYOBJECT.MYMETHOD()
  FROM MYTABLE T
  WHERE T.MYOBJECT.MYMETHOD()>10; But if you use a procedure, how do you call it? The only thing I found in Oracle doc was that you need to qualify the name with the object variable using dot notation, but it provides neither a context nor an example.

• David Gallardo