I am trying to do an insert from a 734 db to an 8174 db over a dblink using select and am getting:

my suedo sql is:
insert into [Email Address Removed] (.....)
select .... from whatever;

which results in:

INSERT INTO apps.[Email Address Removed] at line 1:
ORA-00920: invalid relational operator
ORA-02063: preceding line from PRD7
ORA-02063: preceding 2 lines from ORAFINAPPS



I see hits on metalink but, they seem to relate to using "not in" for the select;s where clause which I am not.

Ideas???

Mike


Oracle LazyDBA home page