oracle 警告,ORACLE SQL方法产生警告

我无法获得以下成员编译方法(count_single_buses)。非常感谢任何有关我的代码语法错误的建议。

CREATE OR REPLACE TYPE BodyModel2_Type AS OBJECT(

ModelID INTEGER,

ModelName VARCHAR2(45),

FloorType VARCHAR2(45),

Manufacturer VARCHAR2(45),

Length NUMBER(8,2),

Width NUMBER(8,2),

NoOfAxles INTEGER,

MEMBER FUNCTION count_single_buses(ModelID INTEGER) RETURN INTEGER);

/

CREATE OR REPLACE TYPE BODY BodyModel2_Type AS

MEMBER FUNCTION count_single_buses(ModelID INTEGER) RETURN INTEGER IS

N INTEGER;

BEGIN

N := (SELECT COUNT(BODYMODELREF) FROM SINGLEDECKBUS_TABLE S

WHERE S.BODYMODELREF = ModelID);

RETURN N;

END count_single_buses;

END;

- 编辑 -

感谢@Ravi，我设法解决了这个问题，我纠正了我的SQL语法并将结果集设置为NUMBER而不是INTEGER。

CREATE OR REPLACE TYPE BODY BodyModel_Type AS

MEMBER FUNCTION count_single_buses(thisModelID INTEGER) RETURN NUMBER IS

NUM NUMBER;

BEGIN

SELECT COUNT(S.BODYMODELREF) INTO NUM FROM SINGLEDECKBUS_TABLE S WHERE S.BODYMODELREF.MODELID = thisModelID;

RETURN NUM;

END count_single_buses;

END;

/

仍然不确定为什么@Ravi的确切代码仍会产生警告，并认为返回计数值时的结果集可能会变成整数。无论如何，代码现在可以运行了。谢谢大家。