编译Oracle软件包后,出现ODP.Net异常Ora-6553 pls-752错误:表函数ftRoutineSchema('package','routinename')。
函数ftRoutineSchema('x','y')访问USER_ARGUMENT表来检索参数信息来构造command.parameters。
我怎样才能避免这种情况?
function ftRoutineSchema(pkg varchar2,Routine varchar2) return tblRoutineSchema PIPELINED is
x recRoutineSchema;
pkN varchar2(100);
rtN varchar2(100);
Begin
FOR Y in ( Select Argument_Name ColumnName
,Data_type DataType
,Position ColumnOrder
,In_out Direction
,Data_length SSize
from user_ARGUMENTS
where package_Name=Upper(pkg)
and object_name=Upper(Routine) order by position
)
LOOP
PIPE ROW(Y);
END LOOP;
Return;
End;