- 论坛徽章:
- 0
|
请教oracle的存储过程为什么报错了
过程如下:
create or replace procedure p_add_all_data as
begin
EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
merge /*+append nologging parallel(t1, */
into TB_DMA_VIP_ALL_ITEMS_0531 t1
using (select *
from cmc_xyk_con
) t2
on (t1.indparty_id = t2.indparty_id)
when matched then
update
set t1.OLD_DAY = nvl(t2.old_day,0);
commit;
end p_add_all_data;
创建的时候没有报错,但是运行的时候就报错我输入:EXECUTE p_add_all_data ;
报错:
ORA-06550: line 2,column 7;
PLS-00905: object p_add_all_data is invalid
求高手帮忙解决,不知道错在哪儿了(我运行的用户已经具备了DBA权限),谢谢。 |
|