不能实例化一个type ,求请教
- SQL code
create or replace PACKAGE pkTypeASTYPE arrayNum IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;END pkType;create or replace function sfRtCC0100_SCB( l_no IN NUMBER, l_id IN VARCHAR2, l_cc OUT NUMBER, l_aaNoArray OUT pkType.arrayNum ) RETURN INTEGERISBEGIN l_cc := 12; l_aaNoArray := new pkType.arrayNum(); -- 这边报PLS-00222错误 END;
[解决办法]
函数中没有return啊
[解决办法]
这样写试试:
l_aaNoArray pkType.arrayNum := new pkType.arrayNum();