declare
BEGIN INSERT INTO A.表1 SELECT * FROM B.表1;
COMMIT;EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
------------------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE xxx
ISBEGIN INSERT INTO A.表1 SELECT * FROM B.表1;
COMMIT;EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
/
xxx编译报错 说是找不到A.表1
那为什么执行好用啊 应该如何解决
A B 为不同的用户 想把B的表1的数据插入到A的表1
GRANT INDEX ON "A"."表1" TO "B" WITH GRANT OPTION
还是报错
提示错误变成没有权限了~ORA-01031
还是报错
提示错误变成没有权限了~ORA-01031
--在b用户下
GRANT select ON "B"."表1" TO "A" WITH GRANT OPTION
--在a用户下
CREATE OR REPLACE PROCEDURE xxx
ISBEGIN INSERT INTO A.表1 SELECT * FROM B.表1;
COMMIT;EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
grant update,delete,insert on B.表1 to user
grant select on A.表1 to user
grant select on B.表1 to user