René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Member procedures/functions [Object Oriented Oracle]

create type foo_type as object (
  
  foo number,

  member procedure proc(p in number),
  member function  func(p in number) return number
);
/

create type body foo_type as 

  member procedure proc(p in number) is begin
    foo := p*2;
  end proc;

  member function func(p in number) return number is begin
    return foo/p;
  end func;
end;
/
A member procedure/function can be final or not final.