Trigger via DatabaseLink

Hi folks,

I've got a strange problem. I try to forward data from my local 9i to a remote 8i via a trigger by use of a dblink.

So I did

CREATE PUBLIC DATABASE LINK myLink CONNECT TO user IDENTIFIED BY pwd USING 'host';

CREATE OR REPLACE TRIGGER myTrigger AFTER INSERT ON myTable FOR EACH ROW DECLARE
  rID NUMBER;
BEGIN
  SELECT remoteID INTO rID FROM conversiontable WHERE localID = :NEW.id;

  INSERT INTO remoteTable_at_myLink (dt,id,value) VALUES (:NEW.dt, rID, :NEW.value);
END; In SQLPlus the above insert works. But when I execute the CREATE TRIGGER I get

    ORA-02083: database name has illegal character '-'

at the position after INSERT INTO.

When I looked on the internet several sources stated that this syntax should work.
A possible work around might be a synonym but why does it not work as is?!!!???!??!

Thanks

AndyR Received on Tue Feb 17 2004 - 11:02:47 CST