orastef schreef:
> We run ORACLE 9iR2 on Sun Solaris and have the requirenments to use
> SSL and firewall.
>
> Because of firewall problems e.g. NAT we use on the top CMAN (ORACLE
> Connection Manager). This works fine expect of transfering BLOBs to a
> remote DB.
>
> We can insert into a table of the remote-db successful an value e.g.
> number. But when I try to insert a blob there is coming a timeout.
>
> Do anybody have experience with this. Can there be a solution if we
> set network parameter? Please leave a message.
>
How exactly do you insert a blob?
It does not work from a select statement (insert into
select field, blob from).
You can insert without the blob, and update the record with
the blob contents later (at least - 8i accepted that - you're
on 9iR2...)
See the Large Objects chapters of the Programmers guide - there
are quite some restrictions on LOBs over db links!
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Fri Mar 02 2007 - 12:56:48 CST
