- 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();