00604: 递归 SQL 级别 1 出现错误
CREATE OR REPLACE TRIGGER ntbms_m_checkjournal
before insert or delete on checkjournal for each row
begin
if inserting then
insert into m_checkjournal@tontbms (cid, cdate, ctime, cname, csid, cdesc1, cdesc2, cdesc3) values(:new.cid,:new.cdate,:new.ctime,:new.cname,:new.csid,
:new.cdesc1, :new.cdesc2, :new.cdesc3);
elsif deleting then
delete from m_checkjournal@tontbms where cid=:old.cid and cdate=:old.cdate;
end if;
end ntbms_m_checkjournal;
0/0 ORA-04052: 在查找远程对象 NTBMS.M_CHECKJOURNAL@TONTBMS.REGRESS.RDBMS.DEV.US.ORACLE.COM 时出错 ORA-00604: 递归 SQL 级别 1 出现错误
ORA-01017: invalid username/password;
logon denied ORA-02063: 紧接着 line (起自 TONTBMS)
------解决方案--------------------你的DBLINK TONTBMS的用户密码不对,重新创建DBLINK。
------解决方案--------------------tontbms是个db link吧?检查创建db link时候指定的username/password是否正确
------解决方案--------------------是不是创建后被修改过了?
你直接用sqlplus连接tontbms能成功吗?
------解决方案--------------------确认link是有效的