Sorry not giving error
With ORACLE user, it works fine and show as :
-------------------
Content-Type: text/html; charset=ISO-8859-1
ALLEN
-------------------
With ROOT User, it shows :
-------------------
Content-Type: text/html; charset=ISO-8859-1
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object file: No
such file or directory at
/usr/local/lib/perl5/5.6.1/i686-linux/DynaLoader.pm line 206.
at (eval 6) line 3
Compilation failed in require at (eval 6) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /home/httpd/cgi-bin/test/mailme.cgi line 16
------------------
I think, that the prob. is with some rights ?? is it ?
Denis
----- Original Message -----
From: "Sterin, Ilya" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, June 24, 2001 9:40 AM
Subject: RE: DBI using HTTP
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, June 23, 2001 3:09 AM
> > To: [EMAIL PROTECTED]
> > Subject: DBI using HTTP
> >
> >
> > Hi gurus,
> >
> > I have this scrip as follow :
> >
> > #!/usr/local/bin/perl
> > use CGI qw/:standard/ ;
> > print header;
> > use DBI;
> > $host = 'aaa.com';
> > $sid = 'oralin';
> > $user = 'scott';
> > $passwd = 'tiger';
> > #$dbh = DBI->connect("DBI:Oracle", $user, $passwd);
> > $dbh = DBI->connect("DBI:Oracle:host=$host;sid=$sid", $user,
$passwd);
> > $sth = $dbh->prepare("select ename from emp where empno = 7499");
> > $sth->execute();
> > print $sth->fetchrow();
> >
> > When i execute this from a server with a user "oracle", it works fine.
But
> > when i call this from HTTP protocol, it does not show anything ???.
Even,
> > with a "root" user, it shows error.
>
> What error? You need to be a little bit more specific.
>
> >
> > Do i have to set any variables for DBI or ??
>
> Yes, but again we don't know the error you are getting. Insert this line
on
> top 'use CGI qw(fatalsToBrowser);' and rerun the script.
>
> Ilya
>
>
>
> >
> > pl help
> >
> > Denis
