Re: PRO C for two database

From: <abhi147_at_gmail.com>
Date: 3 Sep 2006 19:35:21 -0700
Message-ID: <1157337321.830361.108930@i3g2000cwc.googlegroups.com>

Sybrand Bakker wrote:
> On 31 Aug 2006 22:23:06 -0700, abhi147_at_gmail.com wrote:
>
> >Hi ,
> >
> > I need to connect to two databases(Oracle 8.0.5 and 10g) . What
> >should be the $ORACLE_HOME for such a case ?
> >
> >Thanks!
>
> AFAIK it's not going to work, because 8.0.5 won't communicate with 10g
> and vice versa.
> Too many major releases in between.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Hi ,

Actually it's okay if it doesn't communicate . But can I have some serial connections i.e., connect to 10g , get the data , close the 10g connection , then connect to 8 and execute some stored procedures .

In tha case , what should my Environment variables link $ORACLE_HOME and $LD_LIBRARY_PATH should be ?

Thanks ! Received on Sun Sep 03 2006 - 21:35:21 CDT