Greetings, all!
I have been using stored procedures from Cobol and am comfortable in their
usage and am trying to do the same thing with perl's DBI::DB2. I think I'm
close, but still can't quite to get it work.
Docs tell me that Oracle's DBI can do this (not portable), but am
wondering if a
what I understand is that the LD_LIBRARY_PATH must be set within the profile
of the user under which the web server is running, and not in the perl %ENV
hash. I think you can edit the .profile of whatever user is running the web
server to add or export that ENV variable.
That is the next issue I
- You may want to try not using a BEGIN block when specifying your PATH
variables.
- Better yet, you should set up your webserver to run as a specific user,
and give
that user the basic environment (including PATH variables) that you need.
It is
better to do this than to run the server as
Well what is not working. You need to give us an error message and not just
not working. There can be lots of reasons for a script to fail. Probably
the most popular is because your environment is not set up correctly for the
user nobody or www. Also did you set your script permissions to chmo
one more addendum: I'm not sure if this solves the problem when using CPAN.
I did end up just cd ing to the DBD-Oracle directory, then running perl
Makefile.PL, then make,. make test, make install and it all worked fine. In
fact, it worked fine even before I had all those files but the connection
Ralph, I had exactly the same problem but I solved it last night: I sent
this to another user on the list but I feel I should repeat it to the list
to help anyone in a similar situation. Here is my solution, I hope it helps:
My problem was that I needed to compile/make/install DBD::Oracle on a
ma
You must have Oracle client installed, which also installs all required libs
to compiler DBD::Oracle. When installing it should configure the
environment properly for you.
Ilya
> -Original Message-
> From: Lary Ecker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 26, 2001 4:38 AM
> T
Alan Kong wrote:
>
> Hi DBI experts,
>
> I'm trying to install oracle driver, DBD:Oracle on a HP900 for Oracle 8.1.7.
> DBI-1.18 is installed successfully, but there is problem on 'make' step when
> installing DBD::Oracle, where the error message stated that nbeq8 cannot be
> found. Does anyone
Hello DBI::Users,
I have been trying in vain for the last couple of days to
successfully run the make tests of DBD-Oracle-1.07 prior to the
driver's installation :-((
These are my system particulars:
# uname -srvm
HP-UX B.11.00 U 9000/800
# getconf KERNEL_BITS
64
# perl -v|head -2
This is perl
Where should I find OCi.dll ?
If I connect the server with hostname and port, do I need any local software
installation except dbi and dbd::oracle ?
where can I find a document that says what are the requirements for connecting to
Oracle with perl: software installations, system variables etc.
Hi
This is the first time I am using the dbi users group.
Before reporting this problem I surf the web a lot and understand that so many users
has similar problems.
I tried to use the suggestions mentioned and still I am stuck.
My problem is I use BEGIN block in .cgi script to setup ORACLE_HO
I retrieved mailing list archive entry and applied the patch to dbdimp.c,
but alas, the same problem happens.
everything runs okay until t/long test. It then hangs on the 20/143 test.
any other info I can send to the list?
> -Original Message-
> From: Groshert, Annika [SMTP:[EMAIL PROT
I have a problem with the oracle dbi with trigger active.
I have created some tables with triggers. When I do a simple select for the
tables in my code I get nothing back however the tables without trigger display
the output. I check my trace log and no errors where found just zero returns. I
ru
- Original Message -
From: "MADI REDDY GARI SUBBA REDDY" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 12:34 AM
Subject: Require help
> Dear Tim,
>
> Could you please help me to install the DBI on Win NT?
>
> Please give me URLs to
Hi DBI experts,
I'm trying to install oracle driver, DBD:Oracle on a HP900 for Oracle 8.1.7.
DBI-1.18 is installed successfully, but there is problem on 'make' step when
installing DBD::Oracle, where the error message stated that nbeq8 cannot be
found. Does anyone have any idea on how to solve
> -Original Message-
> From: Stacy Mader [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 26, 2001 2:39 AM
> To: DBI Users
> Subject: Joined Views
>
>
> A while back I asked about querying two tables linked by a
> common field
> (see
> http://www.xray.mpe.mpg.de/mailing-lists/dbi/200
As far as I know these attributes are kept private and can't be accessed
through the $dbh object, but I might be wrong:) If you are connecting using
these attributes, why can't you just keep them for later reference?
Ilya
-Original Message-
From: Igor Feldman
To: [EMAIL PROTECTED]
Sent:
Hello !
Can any body help me with identify server name from connection descriptor while I've
alredy been connected to Oracle DB?
I'm looking for way in which I could describe server name from connection
descriptor $dbh insted looking into tnsnames.ora file in order to detect hostname
(server) re
A while back I asked about querying two tables linked by a common field
(see
http://www.xray.mpe.mpg.de/mailing-lists/dbi/2001-02/msg00252.html).
Instead of typing alot of code, I have simply joined the two tables
together
like this:
create view report_response as
(select a.fault_no,
issue,
date
Look in the mailing list at:
Re: DBD-Oracle-1.07: "make test" failures
Fri, 20 Jul 2001
I had the same problem and the patch fixed it.
Give it a try. :-)
Annika Groshert
T-Systems
debis Systemhaus GmbH
TCS-PB - Netzwerkmanagement
Hausanschrift: Erich-Herion-Straße 11-13, 70736 Fellbach
Telefon
20 matches
Mail list logo