CREATE OR REPLACE TYPE person_typ1 AS OBJECT(
name VARCHAR2(10),gender VARCHAR2(2),birthdate DATE
);
DECLARE
v_d PERSON_TYP1;
BEGIN
v_d:='ddd';
dbms_output.put_line(v_d.name);
END;
------解决方案--------------------
- SQL code
--哥們,不是你那樣用的DECLAREv_d PERSON_TYP1;BEGIN v_d:=PERSON_TYP1('1','2',sysdate); dbms_output.put_line(v_d.name);END;/