在ORACLE存储过程中,INSERT到远程SQLServer数据库的时候出现ORA-02025错误,不使用游标的话,有无解决办法?
INSERT INTO TAB_STOCK@DCLINK
("ID","State","Note")
SELECt ID,STATE,NOTE
FROM TAB_MASTER;
错误:ORA-02025:SQL 语句的所有表均必须在远程数据库中
在ORACLE存储过程中,INSERT到远程SQLServer数据库的时候出现ORA-02025错误,不使用游标的话,有无解决办法?
INSERT INTO TAB_STOCK@DCLINK
("ID","State","Note")
SELECt ID,STATE,NOTE
FROM TAB_MASTER;
错误:ORA-02025:SQL 语句的所有表均必须在远程数据库中
for aRecord in SELECt ID,STATE,NOTE FROM TAB_MASTER loop
INSERT INTO TAB_STOCK@DCLINK ("ID","State","Note") values(aRecord.ID, aRecord.State, aRecord.Note);
end;