create or replace procedure WJW_TEST(IN_BLNG_CDV IN VARCHAR2, IN_PST_CDV IN VARCHAR2,OUT_SY OUT LIST_VARCHAR, OUT_SRCH_COUNT OUT NUMBER, OUT_STATUS OUT NUMBER, OUT_SQLCODE OUT NUMBER) is
begin
OUT_SRCH_COUNT:=1;
OUT_SY:=LIST_VARCHAR('111','222','333');
end WJW_TEST;
/
}
----------------------------------------------------------
create or replace type para as varray(1000) of varchar2(4000)
---------------------------------------------------------------
create or replace procedure saveAurhorize(
inputValue in para,
inputLength in number,
busiNo in number,
retValue out varchar2) is
begin
retValue:='111';
end;
-----------------------------------------------------------------------
结果为:
111