On 2008-01-29 19:14:51 -0800, Jonathan Leffler wrote:
On Jan 29, 2008 5:31 AM, Mohammed, Shafi [EMAIL PROTECTED]
wrote:
I need following files.
As has already been explained to you -- you need to get those files from a
legitimate source, namely Oracle, or your authorized Oracle
To: John Scoles
Cc: Mohammed, Shafi; dbi-users@perl.org
Subject: Re: DBI-DBD::ORACLE EROR
Hello!
On Tue, 29 Jan 2008, John Scoles wrote:
It would be nice to see the output for the Makefile.PL as well
Looks like either one of few things
1) you do not have the full oracle 9
Hello!
On Tue, 29 Jan 2008, John Scoles wrote:
It would be nice to see the output for the Makefile.PL as well
Looks like either one of few things
1) you do not have the full oracle 9 client installed
2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly
It would be nice to see the output for the Makefile.PL as well
Looks like either one of few things
1) you do not have the full oracle 9 client installed
2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly
3) you do not have execute permissions on the *.h files
Have a look at
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 29, 2008 6:56 PM
To: John Scoles
Cc: Mohammed, Shafi; dbi-users@perl.org
Subject: Re: DBI-DBD::ORACLE EROR
Hello!
On Tue, 29 Jan 2008, John Scoles wrote:
It would be nice to see the output for the Makefile.PL as well
Looks
On Jan 29, 2008 5:31 AM, Mohammed, Shafi [EMAIL PROTECTED]
wrote:
I need following files.
As has already been explained to you -- you need to get those files from a
legitimate source, namely Oracle, or your authorized Oracle supplier.
Nothing else will work; no-one who respects the law will
Might be useful to mention that we use DBI version 1.37 and DBD::Oracle
version 1.14.
_
From: Dan Werner [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 4:36 PM
To: 'dbi-users@perl.org'
Subject: DBI/DBD::Oracle and Oracle 10g
Should it be necessary to recompile DBI and/or
On Fri, Aug 26, 2005 at 10:58:22AM -0400, Ford, Richard wrote:
We are encountering a problem when we connect to an Oracle database and do not
provide the database name in the connect string.
The ORACLE_HOME that the DBD was compiled against is
/app/oracle/client
The Oracle ENV variables
; dbi-users@perl.org
Subject: RE: DBI DBD-Oracle connection failure woth ORA-12705
SOLVED Thanks Ron,
I have another oracle home for Oracle9ias . NLS_LANG was set right in
The database oracle_home, but set as NA in the IAS home.
I have set an environment variable NLS_LANG so that all homes
Metalink not 158654.1
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Gavin W [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 2:03 AM
To: dbi-users@perl.org
Subject: DBI DBD-Oracle connection failure woth ORA-12705
Environment = Windows XP,
To: dbi-users
cc:
Subject:RE: [dbi] DBD::Oracle, Instantclient and HP-UX...
Michael,
I think with InstantClient OCIEnvCreate fails if you set ORACLE_HOME. You
need
to make sure libclntsh.so is on your dynamic linker search path
(LD_LIBRARY_PATH) and do /not/ set
/2005 13:57
Please respond to [EMAIL PROTECTED]
To:Michael PEPPLER
cc:martin.evans, dbi-users
Subject:RE: [dbi] DBD::Oracle, Instantclient and HP-UX...
Tree setting SHLIB_PATH to the same value as LD_LIBRARY_PATH. Try doing
this before you build DBD::Oracle. (You are doing
Which linux? What is the output of 'perl -V'? What was missing?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Smith, Sharon Michelle (OSLO) [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 1:14 PM
To: dbi-users@perl.org
Subject: DBI
John,
My guess is you do not have the correct Oracle environment set up. See the below
metalink notes:
1012295.102 - HOW TO SUPPORT TWO-TASK COMMON ERRORS
1020408.102 - ORA-03106 WHEN CONNECTING TO UTF8 DATABASE
Also, I would print the Oracle error message when you encounter errors:
George, Jeff has now told you *twice* what you need to do, and you
haven't done what he suggested yet. If you're going to ask for help
here you need to at least try what people suggest. And
just-so-you-know, asking for phone numbers isn't really appropriate.
Here are the ftp url's that Jeff
, June 24, 2004 4:44 AM
To: [EMAIL PROTECTED]; HSIA, GEORGE (SBCSI)
Subject: Re: DBI,DBD-Oracle install for AS Perl URGENT!!
George, Jeff has now told you *twice* what you need to do, and you
haven't done what he suggested yet. If you're going to ask for help
here you need to at least try what
On Mon, 11 Aug 2003 08:48:54 -0500 Forotanrad, Bahman [EMAIL PROTECTED] wrote:
I have several perl scripts which use sybperl. I am in the process of
moving my data off Sybase to Oracle 8i and 9i on AIX 5.1. In order to
re-write my perl scripts to interface with Oracle, I need to use
Thank you Jeff!
I've been getting a few emails from folks looking
for xmlproj.com, and had no place to send them.
This is much appreciated.
Jared
On Monday 07 July 2003 12:22, Jeff Urlwin wrote:
Hi.
I've setup an ActiveState repository for DBI, DBD::Oracle and DBD::ODBC for
use with
On Wed, Jul 09, 2003 at 08:54:52AM -0400, Jeff Urlwin wrote:
I would propose that you instead try to get DBD::Oracle into
the ActiveState repository. (Note that DBD::ODBC already is
there.) From my experience with DBD::mysql I know that
I could NOT agree with you more. However,
perl -MDBI
and
perl -MDBD::Oracle
If either hang, that means that module is installed, if it shows something
about can't find in @INC, then it's not.
Ilya
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 3:36 PM
To: [EMAIL PROTECTED]
Subject:
Hi, Jeff,
Quoting Jeff Urlwin [EMAIL PROTECTED]:
One thing to keep in mind is that you *should* get your
binary built
modules from the same location. So, if you want DBD::Oracle, make
sure you get DBI from my site.
this is what bothers me. First of all, note that the current
Hi, Jeff,
Quoting Jeff Urlwin [EMAIL PROTECTED]:
One thing to keep in mind is that you *should* get your binary built
modules
from the same location. So, if you want DBD::Oracle, make sure you get
DBI from my site.
this is what bothers me. First of all, note that the current release
is
Hi, Jeff,
Quoting Jeff Urlwin [EMAIL PROTECTED]:
Jochen -- I agree with you, but until someone gets Oracle to write it
to ActiveState or ActiveState works it out with Oracle, I'll do the
best I can.
of course I wasn't aware of such legal nonsense. My apologize,
in that case I can of course
Hi, Jeff,
Quoting Jeff Urlwin [EMAIL PROTECTED]:
Jochen -- I agree with you, but until someone gets Oracle
to write it
to ActiveState or ActiveState works it out with Oracle, I'll do the
best I can.
of course I wasn't aware of such legal nonsense. My
apologize, in that
Quoting Jeff Urlwin [EMAIL PROTECTED]:
I don't have a problem with that, in principle. I guess I could talk
to
Jenda Krynicky (sp) too, since he seems to have some modules up and
seems to
use DBI. I don't know Randy, can you send me an e-mail address or
contact
information?
See
Many thanks for this Jeff!
Tim.
On Mon, Jul 07, 2003 at 03:22:33PM -0400, Jeff Urlwin wrote:
Hi.
I've setup an ActiveState repository for DBI, DBD::Oracle and DBD::ODBC for
use with ActiveState's perl (Windows platform) to help resolve the issue
where ActiveState no longer builds
On Wed, 2 Apr 2003 08:33:36 -0800 (PST) steve hatfield [EMAIL PROTECTED] wrote:
I have a question, I have Oracle 8i Client\Server and Oracle 9i client
on my windows 2000 machine. When I connect to a database using DBI :
$dbh = DBI- connect ($connectdbi, $Owner, $Owner2, \%attr);
Which
On Wed, Mar 26, 2003 at 08:07:31AM -0600, Neibarger Scott H wrote:
I'm going to have a multi-threaded daemon application on each TEC server
that will have all of the logic necessary to perform the appropriate
application. Within the TEC rules engine, I will have developed external C
shared
PROTECTED]
Subject: Re: DBI/DBD Oracle dumps core on Solaris 8 when reference
cursor returned untouched
Srdjan,
Hi,
Howdy,
Versions:
Perl: 5.6.1
Mine is 5.8
DBI: 1.32
DBD-Oracle: 1.12
Mine are similar
Operating System: Solaris 5.8
WinNt
Oracle version: 8.1.7
I am 8.1.5
Description
Srdjan,
I have played a bit more
As did I.
I am not sure if the difference in operating systems is significant
(Solaris vs. WinNt)?
Behavior is similar but not the same. In my case all the software is on one
machine (I am not connecting remotely).
oerr ORA 24338
24338, 0, statement
Srdjan,
Hi,
Howdy,
Versions:
Perl: 5.6.1
Mine is 5.8
DBI: 1.32
DBD-Oracle: 1.12
Mine are similar
Operating System: Solaris 5.8
WinNt
Oracle version: 8.1.7
I am 8.1.5
Description:
procedure, the program dumps core.
No core dump here unless DBI-trace(n) is set with 'n' 1
Note that the
ORA-01747:
01747, 0, invalid user.table.column, table.column, or column
specification
Looks like due to being called in the subroutine, your SQL text is getting
munged-- have you tried running the script with DBI_TRACE=1 set in the
environment so you can see what's going on?
SRH
--
SRH
PROTECTED]
Subject: Re: DBI/DBD-Oracle
01/11/2003 11:29
On Thu, 16 Jan 2003 10:11:02 -0500 Robert Hansen [EMAIL PROTECTED] wrote:
I really appreciate your suggestion. However, even with this approach we
would be using one version or the other in a given script. We currently
cycle through each database on a given server (regardless of the Oracle
On Fri, 10 Jan 2003 11:57:41 -0500 Robert Hansen [EMAIL PROTECTED] wrote:
I've been experimenting with your idea here and have run into another
snag.
The connection to the 9i database works fine setting the Oracle home to the
one DBD was compiled against (8.1.7) using the following method
On 11 Jan 2003 22:15:08 +0100 Kristian Nielsen [EMAIL PROTECTED] wrote:
Michael A Chase [EMAIL PROTECTED] writes:
I've been pondering this and the best I can come up with is to build
DBD::Oracle twice into separate directories using PREFIX= as an option
(e.g., 'perl Makefile.PL
On Mon, 6 Jan 2003 15:28:02 -0500 Robert Hansen [EMAIL PROTECTED] wrote:
There is no need to write Tim directly.
We started using DBI/DBD-Oracle (on 8i databases) last year and now as we
are starting to introduce 9i databases into our environment we are faced
with some new challenges. We
On Tue, 7 Jan 2003 09:29:09 -0500 Robert Hansen [EMAIL PROTECTED] wrote:
Thanks for the reply. It is certainly possible to do what you have
suggested and in fact we have tested this out and it works fine. However,
we were hoping for a cleaner solution. We currently cycle through the
oratab
On Fri, Nov 01, 2002 at 09:56:45AM -0500, Dave K wrote:
Question: (thanks for staying with me...)
What is:
OCILobLocatorPtr=SCALAR(0x1ddab58)
I had hoped to gain access to the CLOB through it. Is this possible?
You can try using the Oracle::OCI module.
It comes with examples that use
On Thu, May 02, 2002 at 03:08:28PM -0400, James L Godwin wrote:
When I try to do a DBI-Connect, however, I get the following
message which seems to imply that
something hasn't been installed properly:
Can't locate auto/DBI/CONNECT.al in INC (INC contains: C:/Perl/lib
C:/Perl/site/lib
On 20 Apr 2002 00:17:45 -0400 Harvey Cary [EMAIL PROTECTED] wrote:
I have not been able to download DBD-Oracle-1.12 from CPAN. Is their
another location I can download it from?
http://mirror.cpan.org/
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask
- Original Message -
From: Mia [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 18, 2002 12:07
Subject: DBI/DBD-Oracle install on Solaris - compiler necessary?
I'm interested in installing DBI and DBD-Oracle on a Sparc Solaris 2.8
machine, but the system does not have cc or
Most likely. You can do a google search, and I'm sure you'll come up with
quite a bit. Another good thing, is that ActiveState (www.activestate.com)
has an activeperl port to Solaris, so you might want to use that, since they
have quite a big repository and already distribute perl with quite a
Hmmm, and maybe not. You can bind it as SQL_CHAR and it should then
preserve the trailing spaces, though I am not sure how oracle will handle it
on it's side.
Ilya
I think it has to do with the external datatype used in OCIBindBy...:
For VARCHAR2, trailing blanks are stripped.
If you use $dbh-quote(), then the trailing space will be preserved.
Example:
...
$sth = $dbh-prepare(insert into test1 values ('a ', 'a ', 'a '));
$sth-execute;
$a = b ;
$sth = $dbh-prepare(insert into test1 values (?, ?, ?));
$sth-execute($a, $a, $a);
$a = c ;
$a =
Hmmm, and maybe not. You can bind it as SQL_CHAR and it should then
preserve the trailing spaces, though I am not sure how oracle will handle it
on it's side.
Ilya
-Original Message-
From: Sterin, Ilya
To: 'Arjan van Ham '; '[EMAIL PROTECTED] '
Sent: 9/18/01 2:45 PM
Subject: RE: DBI
The latest ones you can find in CPAN.
You might want to use ActiveState's Perl binary and use PPM to install all
you modules.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish
It's a bug. I can't remember how non-trivial it is to fix, but I'll
certainly be taking a look at it wen I next work on DBD::Oracle.
Tim.
On Wed, Apr 11, 2001 at 03:02:47PM -0400, Sherry Y. Cui wrote:
Hi,
I need your big help...
The application we are developing for our client is written
48 matches
Mail list logo