By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create or replace TYPE "MY_ST_GEOMETRY" Authid current_user AS object
(entity integer,numpts integer,minx float(64),
miny float(64),maxx float(64),maxy float(64),
minz float (64),maxz float(64),minm float(64),
maxm float(64),area float(64),len float(64),
srid integer,points blob,
constructor Function my_st_geometry(geom_str clob,srid number) Return self AS result deterministic,
constructor Function my_st_geometry(x number,
y number,
z number,
m number,
srid integer) Return self AS result deterministic) NOT final
create table polygons (
id int,
shape my_st_geometry
)
insert into polygons (id, shape ) VALUES (
1,
my_st_geometry('polygon ((52 28,58 28,58 23,52 23,52 28))', 4326)
);
ORA-04067: not executed, type body "FIDDLE_AVQSLONBWTNNSAYTSJPU.MY_ST_GEOMETRY" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "FIDDLE_AVQSLONBWTNNSAYTSJPU.MY_ST_GEOMETRY"
ORA-06512: at line 1