oracle 无效数据对象解决办法
oracle 无效数据对象
--创建对象类型
create type t_product as object
(
id integer,
name varchar2(15),
description varchar2(22),
price number(5, 2),
days_valid integer,
member function get_sell_by_date renturn date
);
--创建对象体
create type body t_product as
member function get_sell_by_date renturn date is
v_sell_by_date date;
begin
select days_valid + sysdate into v_sell_by_date from dual;
return v_sell_by_date;
end;
end;
--查看对象类型
SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TYPE';
--创建表
create table products(
product t_product,
quantity_in_stock integer
);
为什么建表是报 ora-00902:无效数据对象
------解决思路----------------------
拿去执行了下,惊奇的发现你的return拼错了,写成renturn了,多了一个N,改过来就可以正常执行了
--创建对象类型
create type t_product as object
(
id integer,
name varchar2(15),
description varchar2(22),
price number(5, 2),
days_valid integer,
member function get_sell_by_date renturn date
);
--创建对象体
create type body t_product as
member function get_sell_by_date renturn date is
v_sell_by_date date;
begin
select days_valid + sysdate into v_sell_by_date from dual;
return v_sell_by_date;
end;
end;
--查看对象类型
SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TYPE';
--创建表
create table products(
product t_product,
quantity_in_stock integer
);
为什么建表是报 ora-00902:无效数据对象
------解决思路----------------------
拿去执行了下,惊奇的发现你的return拼错了,写成renturn了,多了一个N,改过来就可以正常执行了