用包作定义,记录类型不是oracle内部存储对象.CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE TABLEMAPPINGINFO IS RECORD(A INTEGER);
END pkg_test;
/create or replace function
GetTableMappingInfo(orderTypeID IN VARCHAR2)
return pkg_test.TABLEMAPPINGINFO
IS
Result pkg_test.TABLEMAPPINGINFO;
beginreturn(Result);
end GetTableMappingInfo;
AS
TYPE TABLEMAPPINGINFO IS RECORD(A INTEGER);
END pkg_test;
/create or replace function
GetTableMappingInfo(orderTypeID IN VARCHAR2)
return pkg_test.TABLEMAPPINGINFO
IS
Result pkg_test.TABLEMAPPINGINFO;
beginreturn(Result);
end GetTableMappingInfo;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货