Re: Using java to move large objects/data over db link?

Thanks for your thoughts on this, Steve.

We are constrained to either build views or packages on the remote system. In the case of views, your approach will work, but there is a strong preference towards using packaged functions and procedures, and that is where my efforts are concentrated.

Inspired by your post, Steve, I tried building a function on "my" machine to calll the function on the remote machine, to see if the LONG RAW datatype could be "shuffled" across the network, (from function to function) but that didn't work.

I suppose I could try to build some kind of system that divided my results into 32k chunks and sent them over one at a time... One of the developers has taken to using a pipe-delimited format to send his data across ;->

I wonder if there are any other approaches we could attempt to solve this problem?

-Bill

Steve Howard wrote:
> Hi Bill,
>
> Without any knowledge of what you are trying to do, do you have the
> username/password used in the link? You can create a java stored
> procedure in the oracle database to which you do have access. If you
> are having issues with what you want to do using the link, it would be
> a regular JDBC call to connect to the other database and do what you
> want, i.e., bypass the database link.
>
> Regards,
>
> Steve
Received on Wed Sep 13 2006 - 14:33:44 CDT