调用下面存贮过程时出现ORA-01403 ORA-06512 错误
哪位高人愿助小弟一把?
CREATE OR REPLACE PROCEDURE up_UpdateData(
p_pamid IN pkg_common.tblItems,
p_memo IN pkg_common.tblsItems,
p_sta OUT NUMBER
) ISBEGIN
FOR i IN 0..p_pamid.COUNT LoopUPDATE --------------------------错误ORA-06512 出现在这里
tabMaininfo
SET
memo = TRIM(p_memo(i));
END Loop;
p_sta := 1;END;
哪位高人愿助小弟一把?
CREATE OR REPLACE PROCEDURE up_UpdateData(
p_pamid IN pkg_common.tblItems,
p_memo IN pkg_common.tblsItems,
p_sta OUT NUMBER
) ISBEGIN
FOR i IN 0..p_pamid.COUNT LoopUPDATE --------------------------错误ORA-06512 出现在这里
tabMaininfo
SET
memo = TRIM(p_memo(i));
END Loop;
p_sta := 1;END;
Action Fix the problem causing the exception or write an exception handler for this condition. It may be necessary to contact the application or database administrator. 需要有个异常处理
不知道 新手,还不知道pkg_common.tblItems如何输入参数值来调试
应该是有的。我传了一行数据的