Oracle Database Discussions

Hi,

We have a customer who has a db link which links from a 9.2.0.5.0 oracle database to a 10.2.0.2.0 oracle database. We also have the exact same setup here internally (9.2.0.5.0 -> 10.2.0.2.0). The issue is that when we try to do a SELECT FROM table (INSERT INTO table@dblink); on our customers system the row is inserted correctly apart from one column which is of type BLOB. No errors are raised but the content of the BLOB field is always empty, all other fields are inserted correctly.

When we try the same thing on our system internally, the BLOB inserts across the db link fine. To add further complication on both our system and our customers system we can successfully select blob content from the 10g database to the 9i database with no problems.

It appears that the problem is only when inserting from the 9i database to the
10g database, and only on our customers system. We cannot replicate this issue.
This has always worked on our system, we have only ever had brief intermittent
success with their system and we don't know why.

Has anyone had similar experiences or problems when using dblinks and blobs?

Does anyone know if we can enable debug/trace in a way such that it will capture the unsuccessful BLOB insert?

Could there potentially be any additional contributing factors, or operating system/network related influences that are preventing the BLOB data from being inserted?

If anybody has any relevant answers to any of these questions we would really appreciate it.

Thanks in advance,

Lee.