Re: Trigger via DatabaseLink

AndyR wrote:

> 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
>
>

And what would the name of the database be? 02083, 00000, "database name has illegal character '%s'"

// *Cause: supplied database name can contain only A-Z, 0-9, '_', '#', '$'
//   '.' and '@' characters.
//

-- 

Regards,
Frank van Bortel