Hi,
I've searched all over and can't seem to find an answer to this... I have
perl code using DBI and DBD::Oracle where I'm trying to selectively copy
rows from one table to another table on a remote database via an Oracle
database link. The SQL is pretty simple and basically looks like the
following:
insert into [EMAIL PROTECTED]
select * from foo
where condition='bar';
What seems to be happening is that DBI (or DBD::Oracle?) is ignoring the
@remote so that it ends up inserting rows back into itself. The very same
query works correctly from sqlplus. Does DBI/DBD::Oracle support database
links? Am I just doing something wrong?
I'm using perl 5.8.0, DBI 1.35, and DBD::Oracle 1.13.
Any help would be greatly appreciated (and may help prevent further hair
loss).
Thanks much,
-Allen