Oracle 18c

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 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


CREATE TYPE robot_t AS OBJECT (
  name VARCHAR2 (100) /*
, model_proc VARCHAR2 (100)
, ves VARCHAR2 (100)*/
, MEMBER FUNCTION to_string
       RETURN VARCHAR2
) NOT FINAL;
/
CREATE OR REPLACE TYPE BODY robot_t
is
  MEMBER FUNCTION to_string RETURN VARCHAR2
  is
  begin
    RETURN 'Робот '|| self.name || ' идет';
  end;
end;
/
CREATE TYPE sv_va_robot_t UNDER robot_t (
  name VARCHAR2 (100)
, model_proc VARCHAR2 (100)
, ves VARCHAR2 (100)
, OVERRIDING MEMBER FUNCTION to_string RETURN VARCHAR2
);
/
ORA-24344: success with compilation error

select * from user_errors


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


SV_VA_ROBOT_T
TYPE
1
2
3
PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted
ERROR
410

SV_VA_ROBOT_T
TYPE
2
0
0
PL/SQL: Compilation unit analysis terminated
ERROR
0


CREATE OR REPLACE TYPE BODY sv_va_robot_t
IS
  OVERRIDING MEMBER FUNCTION to_string RETURN VARCHAR2
  IS
  BEGIN
    RETURN 'Робот говорит, что у него есть имя - '
 || self.name 
 || ' модель процессора - '
 || self.model_proc
 || ' вес - '
 || self.ves
 || (SELF as robot_t).to_string;
 END;
END;
/
ORA-24344: success with compilation error

declare
type shema_robota is table of robot_t;
shema shema_robota := shema_robota ( robot_t ('Жора')
                                   , sv_va_robot_t('Игорь', 'pentium g4560', '87 тонны') );
begin
  for x in 1..shema.count
    loop
      DBMS_OUTPUT.put_line (RPAD ('=', 60, '='));
      DBMS_OUTPUT.put_line (shema (x).to_string);
 END LOOP;
END;
/
ORA-06550: line 4, column 38:
PLS-00905: object FIDDLE_PMJFMFKMSUMOZTAPKPYB.SV_VA_ROBOT_T is invalid
ORA-06550: line 3, column 7:
PL/SQL: Item ignored
ORA-06550: line 6, column 15:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 6, column 3:
PL/SQL: Statement ignored

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
SV_VA_ROBOT_T	TYPE	1	2	3	PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted	ERROR	410
SV_VA_ROBOT_T	TYPE	2	0	0	PL/SQL: Compilation unit analysis terminated	ERROR	0