At 01:30 PM 4/24/2002 -0500, you wrote:
>Hi Andrew,
>
>It seems I was not clear enough, let me explain,
>
>When compiling DBD-Informix, the INFORMIXDIR will
>be hard coded in the in the compiled DBD-Informix,
>
>This way If the INFORMIXDIR changes for any reason,
>I will not be able to use DBD-Informix.
>
>Because of the above, I set the environment variable:
>DBD_INFORMIX_RELOCATABLE_INFORMIXDIR to yes before
>compiling DBD-Informix, this way the INFORMIXDIR
>will not be hard coded in the compiled stuff and I will
>need to set LD_LIBRARY_PATH or SHLIB_PATH in order
>to use DBD-Informix, so I don't need to worry about
>INFORMIXDIR being changed.
>
>What I am trying to find:
>Is there a similar concept for DBD-Oracle?
>
>Please advice.
I believe the user running the application which employs DBI->DBD:Oracle
must have the $ORACLE_HOME and $PATH settings
that are correct for the local Oracle setup.
Your code's connect string would then provide the needed SID.
The connect string syntax we used has the following syntax:
$dbh = DBI->connect( dbi:Oracle:<Oracle Service Name>, <user>, <pswd>,
{ PrintError => 0, RaiseError => 0,
AutoCommit => 1 }
);
No use of $LD_LIBRARY_PATH or equivalent.
Of course the host machine for the perl application has Oracle client
software installed.
>Regards,
>Mahdi,
>
>
>-----Original Message-----
>From: Andrew Crum [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, April 24, 2002 3:03 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Oracle version of Informix
>DBD_INFORMIX_RELOCATABLE_INFORMIXDIR env variable
>
>
>
>At 03:18 PM 4/24/2002 -0400, you wrote:
> >I think ORACLE_HOME may be what your looking for. Mine's set to
> >"/opt/oracle/product/8.1.7".
>
>Agreed.
>
>You will probably need a few more Oracle parameters set before you're done.
>If you can login as the oracle administrator and then run 'env' to view its
>shell variables,
> you are likely to discover other useful and possibly required
>Oracle-related settings.
>The same might also be found if you can locate a script named like "*oraenv"
>- there are usually a few of them, one for a specific shell syntax.
>
>
> >HTH,
> >Dave
> >
> >On Apr 24, Mahdi A. Sbeih scribed:
> >
> > > Hi all,
> > >
> > > Is there a variable for Oracle like the one used before
> > > installing DBD-Informix in case of relocatable INFORMIXDIR
> > > or in oracle this is completely different.
> > >
> > > I know this may sound simple for you guys, but I am an
> > > Informix DBA, and never used Oracle before, so some
> > > hints will be appreciated.
> > >
> > >
> > >
> > > Regards,
> > > Mahdi.
> > >
> > >
> > >
>
>-----
>Andrew Crum --- Metagenix, Inc.
-----
Andrew Crum --- Metagenix, Inc.
