it would be used though??
Cheers
Quoting Martin J. Evans (martin.ev...@easysoft.com):
On 27/10/2011 17:43, John Scoles wrote:
Hmm!!
Well yes could be done but not as part of any release of DBD::Oracle it
would have to be you own hacked version
Why is that John? What
Glad we can help.
Keep us informed on how it works out
cheers
John
Date: Thu, 27 Oct 2011 14:39:15 -0400
From: bro...@deseret.com
To: byter...@hotmail.com
CC: martin.ev...@easysoft.com; dbi-users@perl.org
Subject: Re: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh
Ok
there is bound to be a few that
slip though the cracks.
Cheers
John Scoles
Date: Sat, 15 Oct 2011 15:24:59 -0400
Subject: Re: DBD::Oracle 1.25 and DRCP
From: frie...@gmail.com
To: byter...@hotmail.com
CC: dbi-users@perl.org
Thanks John!
that seems to have fixed it:
charset id=1, name
the other flavours of connecting a try as well
Cheers
John
Date: Fri, 14 Oct 2011 15:06:48 -0400
Subject: Re: DBD::Oracle 1.25 and DRCP
From: frie...@gmail.com
To: dbi-users@perl.org
Hey Cliff and John,
on Sept 22, 2010 you posted about issues you were having with getting
Oracle DRCP
in the trace
Useing DRCP Connection
just after it reports on your NLS env
Just need to connect no need for any qurreries etc
cheers
John Scoles
Date: Fri, 14 Oct 2011 18:53:09 -0400
Subject: Re: DBD::Oracle 1.25 and DRCP
From: frie...@gmail.com
To: byter...@hotmail.com
CC: dbi-users
it for this just for cache of selects but the above would be
one place to start.
Cheers
John
Subject: DBI Proxy + transactions
From: bori...@fides.com
To: dbi-users@perl.org
Date: Tue, 4 Oct 2011 19:58:59 +0400
Hi!
Tell me, please, how can I use db transactions ( $dbh-begin_work
Why even use DBD::ODBC?
Why not use DBD::Oracle?
Cheers
John
Subject: Re: DBD::ODBC fails, SQL*Plus works
From: john...@pharmacy.arizona.edu
Date: Wed, 5 Oct 2011 10:53:48 -0700
CC: dbi-users@perl.org
On Oct 5, 2011, at 9:09 AM, Scott Stansbury wrote:
It returns (after
this helps
Cheers
John Scoles
Subject: Connecting to Oracle 11g with perl 5.6.1
Date: Tue, 4 Oct 2011 21:04:16 +0530
From: s...@cisco.com
To: dbi-users@perl.org
Hi,
I have a perl program that is using Perl 5.6.1 and Oracle 10g. We have
migrated the database from 10g to 11g. I modified
tha handle. Also make sure you are not trying to reconnect each time
as both of these actions are rather heavy on resources.
Cheers
John
You will most likely have to reinstall DBD::Oracle and the Oracle client one
your new target linux box
try
Perl -MDBD::Oracle -e 'print DBD::Oracle::VERSION'
To see if it is installed on your new box.
If not you will have to get it from CPAN as well as an Oracle Client
I would use the
On 09/01/11 2:10 AM, Clive Eisen wrote:
What 'simple' piece of sql do the team suggest?
select 1 from systables where tabid =1
why not just SELECT TRUE; ?
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
a schema designed
by a spreadsheet user. It violates the tenets of relational data design.
If the table was properly structured, the required data could be queried
with a single JOIN, albeit not in the exact output form shown.
--
john r pierceN 37, W 122
santa cruz
::Oracle
Not sure if this will work in DBI 1.30 though as I do not have that code base
arount to look at.
Hope this helps
cheers
John
Subject: Re: Turn off Issuing rollback... warning for AutoCommit.
From: da...@kineticode.com
Date: Wed, 24 Aug 2011 09:52:22 -0700
CC: dbi-users
Doesn't seem to be a DBD for Netezza but you can connect though 'ODBC' so you
will be able to use DBI.
Perhaps in the long run you might want to write a DBD yourself as long as there
is some sort of interface from IBM.
Doesn't seem to be much of anything on Netezza on CPAN yet.
Check the NLS_LANG and other local ENV setting such as Country etc. setting on
the box where your client resides.
You might have to change it to one that can display.
Make sure the data is going in correctly first and that your display can
display it.
Hope this helps.
Cheers
John
statement using a SQL JOIN, and do so far more
efficiently than what you show above, as it will reduce round trips to
the database.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
What happens with Apache::DBI?
-Original Message-
From: David Nicol [mailto:davidni...@gmail.com]
Sent: Tuesday, July 12, 2011 12:00 PM
To: ZhangJun
Cc: dbi-users@perl.org
Subject: Re: is it possible to use two sth from same dbh at the same time ?
when it isn't possible, you can create
but you will get a whold lot more tracing
Cheers
John
Date: Mon, 6 Jun 2011 10:57:24 +0200
From: y...@mailueberfall.de
Subject: Re: RE: perl DBI Oracle NCLOB fetching
To: byter...@hotmail.com; dbi-users@perl.org
Hello,
setting dbd_verbose leads to no additional output. It's only:
DBD
We will need a little more to go on than that. At a min we need
1) DBI version
2) DBD driver name and version
3) Database system name and version
4) OS
What would be perfect is a perl script that recreates the error.
Cheers
DBI users
Subject: Segmentation fault
Date: Mon, 6 Jun 2011
Simple connection problem.
Try to connect SQLPlus if you can do that then you can use DBD::Oracel
Try the same connection string in DBD:Oracle
Hope this helps
cheers
John
CC: dbi-users@perl.org
From: jona...@gmail.com
Subject: Re: Need Help with DBI for oracle
Date: Fri, 3 Jun 2011
Well looking at the code there does not seem to be any get_info in DBD::Sybase
so I think you are out of luck
Cheers
John
From: eric.b...@barclayscapital.com
To: dbi-users@perl.org
Date: Fri, 3 Jun 2011 11:38:59 -0400
Subject: DBD::Sybase and DBI-get_info()
As we migrate our codebase
NLS_CHARACTERSET
NLS_NCHAR_CHARACTERSET
NLS_LANGUAGE
NLS_TERRITORY
These should all match up.
Your DBI is rather old what is you version of DBD::Oracle
you might want to upgrade both
Cheers
John
Date: Fri, 3 Jun 2011 19:03:46 +0200
From: y...@mailueberfall.de
To: dbi-users@perl.org
Subject
Well in that case bounce back to 1.25 which does not use OCIPing and you should
be ok.
Also check which oracle client versions are on both boxes Credits to Navy Beans
that they are different.
Cheers
John
From: stephen.willi...@twcable.com
To: dbi-users@perl.org
Date: Wed, 25 May 2011 17
in DBD::Oracle just
different implementations on OCI clients.
Hope this helps
cheers
John
Date: Tue, 24 May 2011 14:40:54 +0100
From: tim.bu...@pobox.com
To: dbi-users@perl.org
CC: sumiy...@tradewintech.co.jp
Subject: (Fwd) Question about DBD::Oracle
- Forwarded message from Sumiya
Does this have anything to do at all with DBD::Oracle???
You mentioned you are calling this with JAVA??
Where is the Perl code??
From: jaha...@idexcel.com
To: martin.ev...@easysoft.com; dbi-users@perl.org; byter...@hotmail.com;
carlso...@llnl.gov; tim.bu...@pobox.com
Subject: RE: (Fwd)
Date: Wed, 18 May 2011 13:03:34 +0100
John,
Irrespective of I calling in Java or executing it on the SQL developer or in
TOAD, I am getting the same response time when compared to executing the SQL’s
separately
Regards
P S Jameel Ahamed
From: John Scoles [mailto:byter
Try doing a very simple refcursor and see if you still have the same
performance issues.
John
From: P S Jameel Ahamed [mailto:jaha...@idexcel.com]
Sent: Wednesday, May 18, 2011 5:04 AM
To: 'John Scoles'; 'Martin Evans'; dbi-users@perl.org; Carlson, John W.; 'Tim
Bunce'
Subject: RE: (Fwd) Re
When I say simple, I mean on a table with just a few rows. You may want to
look at how many rows are pulled back from the database at a time on your large
table (batching rows).
John
-Original Message-
From: Carlson, John W. [mailto:carlso...@llnl.gov]
Sent: Wednesday, May 18, 2011 9
It looks like you're doing a full table scan to pull back all rows of
tbl_qm_dashboard currently--how many rows does that have?
-Original Message-
From: Carlson, John W. [mailto:carlso...@llnl.gov]
Sent: Wednesday, May 18, 2011 10:05 AM
To: P S Jameel Ahamed; 'John Scoles'; 'Martin
Martin Evans would be the expert on that. But it does sound funny that
TEXTSIZE is working and LongReadLen is not?? LongReadLen should work no matter
the driver.
Perhaps you should try DBD::ADO
From: eric.b...@barclayscapital.com
To: dbi-users@perl.org
Date: Tue, 17 May 2011 12:11:55
ideas. Would need to see code to know what to suggest next. I am
not proposing that my solution is any faster, just different.
John
-Original Message-
From: Tim Bunce [mailto:tim.bu...@pobox.com]
Sent: Tuesday, May 17, 2011 2:18 PM
To: dbi-users@perl.org
Cc: jaha...@idexcel.com
Subject
What is the issue exatly?
It is just slow??
Can you give us some examples code to play with.
Slowness can be caused by anything from low-ban width, poor SQL, a badly
partiioned DB or just too much data??
We need to know the version of DBD::Oracle you are using as well
Cheers
John
Are you uisng activestate Perl?
You will also have to insall DBD::Oracle and an instantclient as well.
If not you will have to compile DBD::Oracle yourself (takes a little while but
it can be done) see the windows readmes to find instrunctions
Cheers
John Scoles
Date: Fri, 29 Apr
On 18/04/2011 3:29 PM, Tim Bunce wrote:
[redirected to dbi-users list]
On Fri, Apr 15, 2011 at 03:05:59PM -0400, John Scoles wrote:
I was given a patch for DBD::Oracle today the just of it was to open
up the OCI commands for starting up and shuting down the DB.
So the question is would
and which C compiler you have.
DBI should install no problem you will most likely hit a snag when it
comes to DBD::Oracle.
Once you give that a try post the results of the Perl Makefile.PL and
the nmake and we will see what we can come up with.
Cheers
John
Hello Experts,
Need to recompile
On 04/07/11 3:10 AM, Ganesh KS wrote:
Hi,
when i run the command,
perl D:\Perl\DBI-1.616\DBI-1.616\Makefile.pl
I am getting the attached error. Please can you tell a possible solution.
read the error message, follow the instructions
for the Release
Cadidates, hint hint nudge nudge ;) ;)
Cheers
John Scoles
Date: Thu, 24 Mar 2011 13:27:20 +0100
From: alexan...@foken.de
To: dbi-users@perl.org
CC: jason.thurs...@gmail.com
Subject: Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W
DBD::Oracle 1.27 compiled, tested and installed
I will have to look into this one in detail later next week as I am off at a
conferace this week. Seems like something got in there.
can you send me run with DBD_Verbose=7
Cheers
John
Date: Thu, 24 Mar 2011 16:26:00 +0100
From: alexan...@foken.de
To: dbi-users@perl.org
Subject: DBD
/DBD
Either way use this
http://search.cpan.org/~pythian/DBD-Oracle-1.28/Oracle.pm#Metadata
to look up the info on about a schema
and this one for a tutorial
http://www.pythian.com/news/wp-content/uploads/introduction-dbd-oracle.html
cheers
John
Please send it to me asap.
Thanks
or SQLCS_EXPLICIT
Can we see more of the trace??
cheers
John
Date: Thu, 10 Mar 2011 09:19:11 +1100
Subject: Understanding trace output
From: ivan.wi...@gmail.com
To: dbi-users@perl.org
Hi,
I'm trying to debug a problem with some code that is erroring when trying
read a CLOB field from
Common to all DBD me thinks. Me thinks you only get in or out scalars (ie
strings) unless you tell your DBD differently
I think you have to use $sth-bind_co
to get your int back as an int try something like this
$sth-bind_col(1, undef, { TYPE = SQL_INTEGER });
hope this helps
From:
into the picture?
-Mark
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, February 17, 2011 4:10 PM
To: dbi-users@perl.org
Subject: Re: Problem with UTF8 and array binding
On 17/02/2011 3:05 PM, Bobak, Mark wrote:
Perhaps you have to declare you in type
On 17/02/2011 3:05 PM, Bobak, Mark wrote:
Perhaps you have to declare you in type as a NCLOB??
Cheers
John
Hi all,
I'm running into a 'PLS-00418: array bind type must match PL/SQL table row
type' error, but only when passing UTF8 data.
The details are as follows. I have a PL/SQL packaged
On 16/02/2011 2:45 AM, Ivan Shmakov wrote:
Well if you are using DBD::Oracle I would just use an Oracle Wallet to
do that for you.
I am sure there are other solutions as well.
Cheers
BTW, what is the best current practice to pass -connect ()
$password to a command-line Perl
On 11/02/2011 1:16 AM, Jayadevan M wrote:
Hmm looking at the env and the MakeFile.pl output perhaps your
ORACLE_HOME is not correct
I would give /u01/app/oracle/product/10.2.0/ a try rather than
/u01/app/oracle/product/10.2.0/db_1
just a suggestion
Cheers
John
Hi,
I am tying to install
/strong
Whit this attribute you can localize the $SIG{} so this should solve the
problems with $SIG{} events that sometimes occur when using DBD::Oracle
Finally I would like to thank Martin Evans for volunteering to be
another co-maintainer of DBD::Oracle
Cheers
John Scoles
Changes
Added
Yeah that has been around for a long time
I will put that into trunk so it will get into 1.28 which should be out next
week sometime.
Thanks allot Charles
Cheers
John
On Fri, Jan 28, 2011 at 10:25 AM, Charles Jardine c...@cam.ac.uk wrote:
Attached is a patch against DBD::Oracle version 1.27
post what happens on the perl Makefile.PL
Cheers
John
On Fri, Jan 28, 2011 at 3:22 PM, Williams, Stephen
stephen.willi...@twcable.com wrote:
Afternoon all,
I am having trouble with trying to compile the DBD drive for Oracle on my
AIX 5.3 TL11 host. I have DBI-1.616 installed on the node fine
='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -
the compiler was cc_r
is that the same as xlC?
and even if it is it has to be the exact same version of xlC
Hope this helps/
If all else fails rebuild your perl from scratch with xlC t if you have a
few hours to wast;)
Cheers
John
-Original
On 26/01/2011 3:35 PM, Bill Ward wrote:
On Wed, Jan 26, 2011 at 12:27 PM, John Scolessco...@pythian.com wrote:
Or, is there some way to verify the OCI environment and reset it when
it is found to be unusable - in other words, trap the
OCIHandleAlloc(OCI_HTYPE_ERROR) error and reconnect
, John Scoles sco...@pythian.com wrote:
On 26/01/2011 3:35 PM, Bill Ward wrote:
On Wed, Jan 26, 2011 at 12:27 PM, John Scolessco...@pythian.com
wrote:
Or, is there some way to verify the OCI environment and reset it when
it is found to be unusable - in other words, trap the
OCIHandleAlloc
On 25/01/2011 10:40 AM, Jonathan Leffler wrote:
On Tue, Jan 25, 2011 at 07:28, John Scoles sco...@pythian.com
mailto:sco...@pythian.com wrote:
On 25/01/2011 10:25 AM, Jonathan Leffler wrote:
Please change the subject line to match the content of the
question
can ignore the 58object tests
On 31lob front the test that fails is a rater obscure OCI check dealing
with the length of a returned lob. I doubt it will give you a problem
cheers
John
Hello All,
I need your help, now I am trying to use DBD::Oracle on Oracle 11g on Solaris
10.
I am blocked
for DBD?
No it is a separate and deprecated hunk of code for perl 4. It may be a
symptom of a deeper problem so we need to see the Makefile.pl and make
output to know for sure.
Cheers
John Scoles
Thanks in advance,
Carl Furst
CMS Developer
MLB Advanced Media
session for your
ORA_CLOB to use to insert all of your clob no matter how big.
I works without the ORA_CLOB because it is just a straight insert up to
a set value ,the value of 'LongReadLen' me thinks?
Hope this helps.
Cheers
John Scoles
the user doesn't have access to v$session and we can't
for 1.28
Cheers
John Scoles
On Wed, Aug 4, 2010 at 2:27 PM, LK lok...@gmail.com wrote:
In the process of moving from centos 4 to a centos 5 machine one
script stopped working. I distilled it down to this problem :
#! /usr/bin/perl -w
use strict;
use DBI;
my $dbh = DBI-connect
I went through this and checked the patch and it was not fully applied
I have patched trunk and your can find it here
http://svn.perl.org/modules/dbd-oracle/trunk
Please note It will be release in 1.28 not 1.27
Cheers
John Scoles
On Tue, Sep 14, 2010 at 6:48 PM, John R Pierce pie
at it.
Cheers
John
On Thu, Dec 16, 2010 at 12:50 PM, Jakob noer sn...@post11.tele.dk wrote:
I have installed DBD-Oracle on an OpenVMS IA64 box.
Versions:
oracle 10.2.0.4 (Client - Db is 11.1.0.7 on solaris)
DBI 1.615
DBD 1.26
Perl 5.8.6
It is as such completed, but I got this error
On 15/12/2010 4:19 PM, ericbamba...@discover.com wrote:
More likely SQLplus is spawning a thread while DBD::Oracle does not.
cheers
John
List,
Truncating the table solved the problem. Since I inserted 2
million rows into a parent table then deleted all of them the Oracle high
On 16/12/2010 7:06 AM, Ludwig, Michael wrote:
-Original Message-
From: John Scoles
More likely SQLplus is spawning a thread while DBD::Oracle does not.
You mean performing the actual work in the background while making
the prompt available for the user to enter the next command?
yep
On 16/12/2010 10:08 AM, ericbamba...@discover.com wrote:
something for 1.29 I guess I am fully booked for 1.28:(
BTW Peat are you able to give the release 1.27 candidate a quick spin??
http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.27-RC1.zip
cheers
John
I won't be getting
On 09/12/2010 10:37 AM, ericbamba...@discover.com wrote:
Sounds odd really
We will have to know the version of DBD::Oracle and DBI for starters
Send me the output from the dbd_verbose=15 so I can check a few things
cheers
John
DBI Users,
I'm having trouble with DBD::Oracle
200 rows. However, the 2 other tools are still fast, its just DBI
that is slow so I dont think its related.
Ha! I very much think so. ;)
Most likely the index of the 200+ is still being updated
Rebuild the indexes and then get back to me
cheers
John
Martin J. Evansmartin.ev
On 09/12/2010 12:24 PM, Martin J. Evans wrote:
On 09/12/10 16:52, ericbamba...@discover.com wrote:
Martin,
do() takes 4 seconds as well. Sorry about the SQL_INTEGER junk. I
was testing things. It takes the same amount of time if I leave off the
types. I remember seeing the trace show
/demo/demo_rdbms32.mk.
(Will continue by using fallback approach.)
Not sure about that one.
I know that in 11g they changed the .mk files up a little. If it
compiles with the fallback is should still work ok.
You are using a 32 bit client I hope??
Cheers
John Scoles
Regards.
Seems
On 11/22/10 11:58 AM, E R wrote:
Hi,
I have two DBD/Oracle/Oracle.so shared libraries. In one case ldd
reports that libocci is linked in, and in another case libocci doesn't
show up.
wild guess says one was linked statically (eg, libocci.a rather than
libocci.so). static linking embeds a
Seems this may be an 11g issue and not a perl/DBI/DBD issuse
Have you applied all the patches for 11to the 11g DB??
Cheers
John Scoles
Date: Fri, 19 Nov 2010 18:06:21 +0100
From: li...@alixen.fr
To: dbi-users@perl.org
Subject: Memory corruption with Perl (DBD::Oracle)
Hi,
Our
(John Scoles) wrote:
You DBD::ORacle is way out of data for you DBI try updating to DBD::Oracle
1.26 ans see what happens
cheers
The error remains the same :( Thanks for all your help. Not sure what
else I can do here.
-bash-3.00$ cat test.db.pl
use strict;
use DBI;
my $dbh = DBI
On 18/11/2010 3:15 PM, Steve Baldwin wrote:
Ok one more to look at for DBD::Oracle 1.28
Hi,
I ran across an issue recently that appears to have existed for quite some
time.
Consider the following script ...
#!/usr/bin/perl -w
use strict;
use warnings;
use DBI;
sub main {
my $dbh =
Well nothing in that pops out at me.
You DBD::ORacle is way out of data for you DBI try updating to DBD::Oracle
1.26 ans see what happens
cheers
On Fri, Nov 12, 2010 at 3:49 PM, i5mast mstrum...@gmail.com wrote:
On Nov 12, 8:24 am, sco...@pythian.com (John Scoles) wrote:
If you can run
On 10/11/2010 11:11 AM, i5mast wrote:
If you can run this with
dbd_verbose=15
on the connect string the post the results it my help us find an answer.
Cheers
John Scoles
I'm using Solaris 10 sparc, Perl 5.8.4, DBI 1.615, instantclient
10.1.0.5, DBD::Oracle 1.16. I compiled and installed
In message aanlkti=txedon_3xr6456qh9ryq5hf9g-uhojcjs+...@mail.gmail.com, SOMN
ATH GANGULY writes:
ora...@prdcmw perl TablespaceFree.pl
Can't locate DBI.pm in @INC (@INC contains:
Where did you install DBI and DBD::Oracle?
John
groenv...@acm.org
On 11/5/2010 5:22 AM, Martin J. Evans wrote:
On 04/11/10 15:37, John Scoles wrote:
You can find Release Candidate 1 for DBD::Oracle 1.27 here
http://svn.perl.org/modules/dbd-oracle/branches/polute/DBD_ORACLE_1_27_RC_1.tar.zip
This release is limited to cleaning up Perl globals within the C
drivers that have been
around for a while (like DBD::Oracle) may break!!
Check out this thread
http://www.nntp.perl.org/group/perl.dbi.dev/2010/08/msg6217.html
for the long version
I am announcing this on dbi-users as well to expand the group of people
who may be using 5.13.3.
Cheers
John Scoles
On 10/29/2010 1:13 PM, Alexander Saip wrote:
Might be a strawberry perl thing??
Can you give it a try with Activestate perl or with and eariler
DBD::Oracle 1.24 or 1.23 or the 10 instant client??
Cheers
John Scoles
Sorry for the delayed response. I had to make Oracle connection work
ASAP
On 10/29/2010 3:25 PM, Alexander Saip wrote:
Ok that sounds like it I will have to fix that if it is in the present
release?
Thanks for pointing that out.
Cheers
John Scoles
I guess not... I eventually managed to build, test and install
DBD::Oracle. The culprit turned out to be oci.def file
precompile
flags are being set but your
Oracle.dll
does not have the the access to these commands files for what ever reason
Me I would get the rest of the instantclient (the SDK) from Oracle and
give it another try
cheers
John Scoles
perl Makefile.PL -s OCIPing
On 10/28/2010 12:18 PM, Alexander Saip wrote:
John,
thanks for your comments. I have successfully installed DBD::Oracle on
a Windows 7 (64-bit) box, but used both 32-bit Strawberry Perl and
Oracle instant client. That may be the way for me to go, unless I can
make the 64-bit stuff work
like this
DBI-connect( dbi:Oracle,testuser, passw...@someoracle.sid)'
hope this helps
cheers
John Scoles
Hi,
i write the sequent script:
###
use DBI;
my $orachehost = *;
my $oracleuser = **;
my $orachepasswd
cheers
John Scoles
Thanks, I've been fortunate enough in my dealings with DBD or DBI that I
haven't had to run prove at this point..
The output from prove -vb t/31lob.t follows:
DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an
unsupporte.
# Failed test 'returned length via
it down
cheers
John Scoles
When I do make test on DBD::Oracle-1.26 with Oracle 11gR2 on Ubuntu
10:04 x64 it fails t/31lob.t test 9. Is this a known problem or am I
doing something wrong.
My perl info:
$ perl -V
Summary of my perl5 (revision 5 version 10 subversion 1) configuration:
Platform
On 10/13/2010 4:12 AM, Martin J. Evans wrote:
On 13/10/10 02:25, Carlson, John W. wrote:
What is the recommended DBD::Oracle version and which instant client
should I compile against for Oracle 11g databases, RedHat el5xen
Linux x86_64 (64bit) architecture? There appears to be several
recent
release. Thanks for
your help!
John
On 10/7/2010 10:20 AM, Mayank Gupta wrote:
When in trouble with Activestate Perl for windows you best bet would be to
1) deinstall all of the Activestate products on your box
2) install only the free version of Perl from here
http://www.activestate.com/activeperl/downloads
3) start again
On 10/8/2010 8:06 AM, Martin J. Evans wrote:
On 08/10/10 12:41, John Scoles wrote:
On 10/7/2010 10:20 AM, Mayank Gupta wrote:
When in trouble with Activestate Perl for windows you best bet would be to
1) deinstall all of the Activestate products on your box
2) install only the free version
.
Pleas give it a try.
That is something that should go in the readme.
cheers
John
On 10/3/2010 12:45 PM, Eric Yellin wrote:
I have yet to try an build DBD::Oracle for FreeBSD so the Makefile might
not be working correctly here are my comments
Hi,
I am trying to compile DBD::Oracle that will work with Oracle 10g on
FreeBSD 6.3
Here is what I have done so far:
1.
On 9/14/2010 12:41 AM, John R Pierce wrote:
On 05/18/10 9:41 AM, Charles Jardine wrote:
On 17/05/10 23:05, John R Pierce wrote:
I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for IBM
AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using IBM XL
C v11.1 + the latest
On 09/14/10 5:35 AM, John Scoles wrote:
Did this ever get tested and entered into the DBD-Oracle release ?
This issue has surfaced at work, so I can probably try testing your
patches some time in the next week or so, possibly on both sparc and
aix/power platforms, but if someone else has
On 9/14/2010 9:17 AM, John R Pierce wrote:
On 09/14/10 5:35 AM, John Scoles wrote:
Did this ever get tested and entered into the DBD-Oracle release ?
This issue has surfaced at work, so I can probably try testing your
patches some time in the next week or so, possibly on both sparc and
aix
On 09/14/10 6:58 AM, John Scoles wrote:
On 9/14/2010 9:17 AM, John R Pierce wrote:
Sorry, I meant, the make test problems with t/58object on big endian
machines like Sparc, IBM Power
Ok that clears it up a little.
I am not sure if it was fixed yet.
Give the latest trunk version a try
Can you run the test suite of DBD::Oracle and see what you get?
If it passes that then it is some sort of Catalyst config problem.
Cheers
John Scoles
Date: Fri, 10 Sep 2010 11:05:30 -0500
Subject: segfault in Oracle libraries when SIGINT received
From: pc88m...@gmail.com
To: dbi
and rebuild DBI and DBD::Oracle with your new
Oracle enviornment.
Post the results of the Perl Makefile.pl and the make install.
That would be the first thing I would try
Cheers
John Scoles
To: dbi-users@perl.org
Subject: Reg DBI Problem
From: raghavendra.kalimise...@tcs.com
Date: Mon
Yep it is something on the XS side of things.
Perhaps the chap who wrote the DBD driver left in some debugging code?
Are you doing any recursive calls or queries??
On Fri, Sep 3, 2010 at 10:35 AM, Jerry Kaidor je...@tr2.com wrote:
Hello,
My name is Jerry Kaidor. I am seeing some cryptic
in there perhaps.
Right now I am of the opinion that the user that is trying the install
does not have full execute permission to the .mk files or AIX has hidden
them someplace else where the makefile cannot find them
cheers
John
-Original Message-
From: vkum...@metlife.com [mailto:vkum
On 08/26/10 10:12 PM, Mahesh y wrote:
John,
Appreciate your quick response and Thank you very much.
Pls, let me know the tools I can use instead of Perl.
Brian suggested SSIS, SQL Server Integration Services, which is in SQL
Server 2005 and 2008
http://www.microsoft.com/sqlserver/2005/en
On 08/06/10 1:37 AM, Robert Roggenbuck wrote:
There is a standard method, wich requires just a working Perl
environment and Internet access:
$ perl -MCPAN -e install 'DBI'
on many platforms, you need to install optional C compilers and
associated libraries to build modules that have C
On 08/06/10 2:31 AM, Satish Bora wrote:
Thanks for some quick insights.
Well I had tried this option earlier and now also. Here is what I get. (I have
attached only error or warnings block)
***
Warning: prerequisite ExtUtils::MakeMaker 6.48
If you can give me another advice I will make a futher test to install a fully
working DBD::Oracle.
Kind regards
Jürgen Großkopf
Von: John Scoles [mailto:byter...@hotmail.com]
Gesendet: Montag, 12. Juli 2010 15:55
An: Großkopf, Jürgen (OFDKA); dbi
I guess you could use DBD::ODBC that does net require an oracle client.
cheers
John Scoles
On Fri, Jul 16, 2010 at 4:50 AM, Martin J. Evans
martin.ev...@easysoft.comwrote:
Vinod Guleria wrote:
Dears,
Could you pls let me know that Is there a way to connect to oracle DB(on
remote
101 - 200 of 919 matches
Mail list logo
