Passing connection to stored procedure

Thread view:

aadilnw@gmail.com - 30 Mar 2007 10:44 GMT

Hi all,

Is there any way other than DBLINK to connect from one oracle server
to another.
Basically i have to purge data from one oracle server to another i.e.
One server is used as
MAIN database server and another is used for history database and
purging is done
using stored procedures.

I donn't kno how to pass the connection and maintain sessions on
different servers in oracle.
Can i use java stored procedures to call my sql stored procedures and
pass the connection

Thanks,

Aadil

Reply to this Message

Arne Vajhøj - 31 Mar 2007 02:22 GMT

> Is there any way other than DBLINK to connect from one oracle server
> to another.
[quoted text clipped - 8 lines]
> Can i use java stored procedures to call my sql stored procedures and
> pass the connection

Database connections are usually not serializable, so I do not
see how you can pass them anywhere.

Arne

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...