oracle 自定义类型数据插入

以前没做过，下午同事问到一insert报错，才发现自己的浅薄，直接上SQL啦

insert into SDE_dlxd 
  (OBJECTID,
   IDREF,
   DOMAIN,
   NAME,
   CODE,
   SHAPE.ENTITY,
   SHAPE.NUMPTS,
   SHAPE.MINX,
   SHAPE.MINY,
   SHAPE.MAXX,
   SHAPE.MAXY,
   SHAPE.MINZ,
   SHAPE.MAXZ,
   SHAPE.MINM,
   SHAPE.MAXM,
   SHAPE.AREA,
   SHAPE.LEN,
   SHAPE.SRID,
   SHAPE.POINTS)
  select k.OBJECTID,
         k.IDREF,
         k.DOMAIN,
         k.NAME,
         k.CODE,
         k.SHAPE.ENTITY,
         k.SHAPE.NUMPTS,
         k.SHAPE.MINX,
         k.SHAPE.MINY,
         k.SHAPE.MAXX,
         k.SHAPE.MAXY,
         k.SHAPE.MINZ,
         k.SHAPE.MAXZ,
         k.SHAPE.MINM,
         k.SHAPE.MAXM,
         k.SHAPE.AREA,
         k.SHAPE.LEN,
         k.SHAPE.SRID,
         k.SHAPE.POINTS
    from linyi_电缆接头bk k

ORA-00904: "SHAPE"."POINTS": 标识符无效

create table SDE_dlxd
(
  OBJECTID INTEGER not null,
  IDREF    NUMBER(18) not null,
  DOMAIN   NVARCHAR2(255),
  NAME     NVARCHAR2(255),
  CODE     NVARCHAR2(255),
  SHAPE    SDE.ST_GEOMETRY
);

CREATE OR REPLACE TYPE SDE.ST_GEOMETRY AUTHID CURRENT_USER AS OBJECT
--C_Type_Release 1007
(
	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 ST_GEOMETRY
	(
		GEOM_STR CLOB,
		SRID     NUMBER
	) RETURN SELF AS RESULT DETERMINISTIC,
	MEMBER FUNCTION ST_AREA RETURN NUMBER,
	MEMBER FUNCTION ST_LEN RETURN NUMBER,
	MEMBER FUNCTION ST_LENGTH RETURN NUMBER,
	MEMBER FUNCTION ST_ENTITY RETURN NUMBER,
	MEMBER FUNCTION ST_NUMPTS RETURN NUMBER,
	MEMBER FUNCTION ST_MINX RETURN NUMBER,
	MEMBER FUNCTION ST_MAXX RETURN NUMBER,
	MEMBER FUNCTION ST_MINY RETURN NUMBER,
	MEMBER FUNCTION ST_MAXY RETURN NUMBER,
	MEMBER FUNCTION ST_MINM RETURN NUMBER,
	MEMBER FUNCTION ST_MAXM RETURN NUMBER,
	MEMBER FUNCTION ST_MINZ RETURN NUMBER,
	MEMBER FUNCTION ST_MAXZ RETURN NUMBER,
	MEMBER FUNCTION ST_SRID RETURN NUMBER,
	STATIC FUNCTION GET_RELEASE RETURN NUMBER
)
NOT FINAL;

INSERT INTO SDE_dlxd

	SELECT K.OBJECTID,
				 K.IDREF,
				 K.DOMAIN,
				 K.NAME,
				 K.CODE,
				 SDE.ST_GEOMETRY(K.SHAPE.ENTITY,
												 K.SHAPE.NUMPTS,
												 K.SHAPE.MINX,
												 K.SHAPE.MINY,
												 K.SHAPE.MAXX,
												 K.SHAPE.MAXY,
												 K.SHAPE.MINZ,
												 K.SHAPE.MAXZ,
												 K.SHAPE.MINM,
												 K.SHAPE.MAXM,
												 K.SHAPE.AREA,
												 K.SHAPE.LEN,
												 K.SHAPE.SRID,
												 K.SHAPE.POINTS)
	FROM   LINYI_dlxdBK K