Hi John,
U dont define $ORACLE_HOME in the connection string.
Either you define it in httpd.conf using SetEnv, or if in a
perl section using PerlSetEnv or even $ORACLE_HOME = '/your/oracle/home'
in your startup script in a BEGIN block.
Thanks
Raj
John wrote:
> Well, how could i define the $ORACLE_HOME in the connection string?
> ----- Original Message -----
> From: "Scott Dial" <[EMAIL PROTECTED]>
> To: "John" <[EMAIL PROTECTED]>
> Sent: Thursday, August 05, 2004 3:03 PM
> Subject: Re: DBD::Oracle seems not working through Apache
> > ie:
> >
> > $ENV{ORACLE_HOME}='/u01/oracle/product/app/root1';
> > $ENV{ORACLE_SID}='prd';
> >
> > On Thu, 5 Aug 2004, John wrote:
> >
> > > Hello
> > >
> > > I have created an perl script that connect to an oracle server and
> execute a query.
> > >
> > > When i run the perl script as root (in the shell) it works great, but
> when i run it through the Apache server (php: system("perl oracle.pl")) it
> fails.
> > >
> > > The apache server runs as wwwrun:www
> > >
> > > Do you know where is the problem?
> > >
> > > Thanks in advance.
> > >
> > > john
> >
> >
