database link problem with insert using select
588400Aug 20 2007 — edited Jan 1 2010Hi
I am writing an sql script in apex and I am accessing a public database link.
I HAVE set global_names = true
the database link name and database global name are exactly the same
now when I try to run the following insert, i get ORA-02019: connection description for remote database not found ORA-02063: preceding line from databaselinkname
insert into schemaname.tablename@databaselinkname (select col1, col2, col3) from tablename;
if i change my insert to the following statement, it works fine
insert into schemaname.tablename@databaselinkname (col1,col2) values(val1,val2).
why is it not working for the previous insert...... any suggestions are appreciated