Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
0


create or replace type obj as object 
  ( var number
  , member function fn(self in out obj, val number) return obj
  , member procedure proc(val number)
  )
;
/
create or replace type body obj
as
  member function fn(self in out obj, val number)
    return obj
    as
    begin
      self.var := val;
      return self;
    end
  ;
  
  member procedure proc(self in out obj, val number)
    as
    begin
      self.var := self.var * val;
    end
  ;
end;
/
declare
  o obj;
begin
  o := obj(4);
  o.fn(5).proc(2);
  dbms_output.put_line(o.var);
end;
/
ORA-06550: line 5, column 3:
PLS-00363: expression 'FIDDLE_LLKSOELCPNHJYTBAARIE.OBJ.FN(O, 5)' cannot be used as an assignment target
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

create or replace type body obj
as
  member function fn(self in out obj, val number)
    return obj
    as
      o obj := self;
    begin
      o.var := val;
      return o;
    end
  ;
  
  member procedure proc(self in out obj, val number)
    as
    begin
      self.var := self.var * val;
    end
  ;
end;
/
declare
  o obj;
begin
  o := obj(4);
  o.fn(5).proc(2);
  dbms_output.put_line(o.var);
end;
/
ORA-06550: line 5, column 3:
PLS-00363: expression 'FIDDLE_LLKSOELCPNHJYTBAARIE.OBJ.FN(O, 5)' cannot be used as an assignment target
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

declare
  o obj;
begin
  o := obj(4);
  o.proc(5).fn(2);
  dbms_output.put_line(o.var);
end;
/
ORA-06550: line 5, column 3:
PLS-00222: no function with name 'PROC' exists in this scope
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

declare
  o obj;
begin
  o := obj(4);
  o.fn(5).fn(2);
  dbms_output.put_line(o.var);
end;
/
ORA-06550: line 5, column 3:
PLS-00221: 'FN' is not a procedure or is undefined
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

declare
  o obj;
begin
  o := obj(4);
  o.proc(5).proc(2);
  dbms_output.put_line(o.var);
end;
/
ORA-06550: line 5, column 3:
PLS-00222: no function with name 'PROC' exists in this scope
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

begin
  obj(4).fn(5).proc(2);
end;
/
ORA-06550: line 2, column 3:
PLS-00363: expression 'OBJ(<null>, 4)' cannot be used as an assignment target
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored