ORA-01422: 实际返回的行数超出请求的行数
做了个函数的例子,随便写了个,如下:
create or replace function type_function(userno1 varchar2)return varchar2istype yyy is table of varchar2(10) index by binary_integer;xx yyy;vv varchar2(40);begin vv :='1233'; select mobileid into xx(20) from tuserinfo where userno=userno1; vv :=xx(20); return vv; end;
正常返回了