John Scoles
On Thu, Jul 1, 2010 at 2:05 AM, Shibi NS shibi...@gmail.com wrote:
I am getting following error
while using DBB::Oracle
httpd: symbol lookup error: /nfs/private/user/sns/tech-stack/
10.06.28.03/linux/lib/perl5/site_perl/5.8.8/i686-linux-64int/auto/DBD/Oracle/Oracle.so:
undefined
of the constant my throw the bug
as well. Might just be one of those majic munbers that pad the results just
enough to make the query run fine.
Hope this helps a little
John Scoles
Date: Fri, 9 Jul 2010 17:47:24 -0400
Subject: Re: sql*net message from client hang
From: dkele
cheers
John Scoles
Subject: DBD-Oracle 1.24b reports ORA-24334 in t/58object.t
Date: Fri, 9 Jul 2010 15:29:45 +0200
From: juergen.grossk...@ofdka.bwl.de
To: dbi-users@perl.org
Hallo,
while executing a make test with DBD-Oracle 1.24b I got an error on my HP
box.
I think
On 07/08/10 1:36 AM, Clive Eisen wrote:
On 08/07/2010 11:18, Martin J. Evans wrote:
Scripting Giri wrote:
Hi Team
Need Your help ASAP.I am getting error while installing the PERL DBI
module,as mentioned below
===
[r...@dba /]# cd /usr/bin/
[r...@dba bin]# cd DBI-1.611
[r...@dba
On 07/07/10 8:37 AM, lippel anna wrote:
Hello guys, I am supposed to have the Sybase Open Client library installed in my pc under the
folder OCS-12_0. I started the installation of DBD::Sybase with the download provided
on CPAN and when I run perl Makefile.PL it tells me Unknown Client Library
that will help narrow things down a bit
cheers
John Scoles
On Thu, Jul 8, 2010 at 5:28 PM, Dan dkele...@gmail.com wrote:
Hello,
We do not have any quotas implemented on our Oracle instance. The simple
select works fine for that hanging block on sqlplus, or if i only execute
it
for that block
The $dbh-{RowCacheSize} = -1; is funny as you are telling the box to only
use 1 byte for RowCach
Try it with '0' and see what happens?
On Thu, Jul 8, 2010 at 7:20 PM, John Scoles sco...@pythian.com wrote:
Hmm DBI 0.67 that is old and the fact you get the same error with the
latest DBI
program and the
Server and if it is not encoded then yes it is in the clear.
I know with DBD::Oracle this connection is encrypted (at least the Pw
and UID) that same should be true of MySql as I think that is part of
the SQL standard is it not??
cheers
John
When connecting to a MySql server
Sharma, Sumit wrote:
Hello All,
Thanks for your suggestions. I have following code written to list all
available drivers along with respective data-sources. But, I get some
errors for Oracle driver, can anybody please suggest the solution?
Thanks
===
#!/usr/local/bin/perl
DBD::Oracle has a native array execute that will save you
alot of processing cycles if you have large (1000+) updates to do.
Cheers
John Scoles
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
...@motorola.com
To: byter...@hotmail.com
CC: dbi-users@perl.org
Hi John,
Started over with ORACLE_USERID, ORACLE_HOME TNS_ADMIN set.
Still not able to connect for DBD.
Yeow
From: John Scoles [mailto:byter...@hotmail.com]
Sent: Friday, June 25, 2010 7:16 PM
To: Yeow Yiew Choong-PBKN64
Subject
-available_drivers;
print \ndata_sources:\n;
print $_\n foreach DBI-data_sources('Oracle');
and post the results here
cheers
John Scoles
Hi all,
My Oracle database NLS language is AMERICAN English.
In DBD::Oracle, what variable/value should I set?
Thanks.
Yeow
-Original Message-
From
, 2010 11:00 AM
To: 'John Scoles'
Cc: dbi-users@perl.org
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Hi all,
Tried TNS_ADMIN =/opt/instantclient_10_2/ and
ORACLE_USERID=scott/ti...@zmy12sora02 but still same error.
I have set ORACLE_HOME=/opt/instantclient_10_2/ and many different
=CGISSRND
TWO_TASK= zmy12sora02
set
I would just drop those two and just use the following
ORACLE_USERID=scott/ti...@zmy12sora02
Hope this helps
John Scoles
Hi all,
I am using tnsnames.ora file in my Oracle Instantclient folder.
The tnsnames.ora file content is listed below:
zmy12sora02
*From:* John Scoles [mailto:sco...@pythian.com]
*Sent:* Friday, June 18, 2010 7:36 PM
*To:* Yeow Yiew Choong-PBKN64
*Subject:* Re: Perl 5.8.9 DBI/DBD::Oracle make test error
last change TNS_ADMIN
set this to the dir where you tnsnames.ora is located
If all
Martin Evans wrote:
http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html
Look for the presentation slides.
Martin
Looks like the link to his slides is broken or at least when I try and
get it I get a corrupt file error!
In message 4c20b25e.3030...@pythian.com, John Scoles writes:
Looks like the link to his slides is broken or at least when I try and
get it I get a corrupt file error!
URL:http://github.com/singingfish/Data-PerlSurvey-2010/raw/master/report/perl_survey.pdf
John
groenv...@acm.org
on the curriculum of more post secondary courses.
cheers all
John Scoles wrote:
Martin Evans wrote:
http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html
Look for the presentation slides.
Martin
Looks like the link to his
Looks like the 64 bit client you are using is not all there. I would
give the instant client 64 a shot. Just to be sure get the SDK as well.
Cheers
John scoles
I am having a problem getting DBD-Oracle to work. It is failing on the make
test on the initial test. If you could please give me
Yeow Yiew Choong-PBKN64 wrote:
I really doubt there is a scott/tiger user on you Oracle box
set the ORACLE_USERID to a value user and password sid combination and
then come back to the list
ie
export ORACLE_USERID=my_user/my_passw...@my_id
Hi,
I have HP-UX 11.11(64bit PA-RISC) and Perl
will warn you to upgrade to perl 5.8)
That will most likely change in 1.25 to be 1.61 DBI and perl 5.8
Cheers
John Scoles
You will have to point the compile job to point to the 32bit client.
Can we the output of the perl Makefile.PL and make runs?
On Fri, Jun 4, 2010 at 2:17 AM, Yeow Yiew Choong-PBKN64 pbk...@motorola.com
wrote:
Hi John,
I use both 32bit 64bit instant client of Oracle, still failed at make
John,
I read in the link, but I do not have Gnu ld 64bit as mentioned in the document.
I cannot do the same for my issue.
However, I found another link
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1095121
which mentioned that most likely cause by mixing 32bit perl using
, ?)));
$sth-bind_param_array(1,\...@in_values);
$sth-execute_array({ArrayTupleStatus=\...@status});
I have never done a full speed test but with 1.17 it took about 25min to
insert 2 million records using the same code and 1.18 it took only about
6 min.
hope this helps
cheers
John
Hi!
Since I came
Never ran into that myself but this link looks like the same error
http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1272030523151+28353475threadId=1078200
cheers
John
Subject: Make Test Failed For DBD-Oracle 1.24
Date: Tue, 1 Jun 2010 19:04:44 +0800
From
Bart Lateur wrote:
2) edit the C source of SQLite and replace the fsync() with fflush(),
which ought to be around 100 times faster, but which isn't garanteed to
withstand computer crashes, if it goes down before the data is finally
stored on disk - not ideal in the eye of ACID perfectionists.
Alexander Foken wrote:
Tim Bunce wrote:
Still got the finish() habit? Let it go!
I often see people posting snippets of example DBI code that call
finish() after a fetch loop. You don't need to do that.
Good to know, escpecially since most example code I've seen has the
call to finish().
/uploads/introduction-dbd-oracle.html
Also, is there anyway to sort of hide the password somehow when using Perl
DBI?
Yes you can use Oracle Wallet or server authentication
cheers
John Scoles
Any advise or feedback will be very much appreciated.
Thanks in advance.
--
Catch Alex Sheeri
You will have to set those values before your modules load.
So you should stick them in the BEGIN and that should work
http://www.compuspec.net/reference/language/perl/BEGIN_and_END.shtml
cheers
John Scoles
On Fri, May 28, 2010 at 3:45 AM, newbie01 perl newbie01.p...@gmail.comwrote:
Hi all
Driver handle.
Not sure if these will give you what you want though. In DBD oracle they
really only just read the TNSNAMES.ora file which as you know may
contain good or bad entries.
Hope this helps
cheers
John Scoles
Thanks in advance
Ed Barlow
Director Database Compliance
Millennium
at
least
3 round trips
1) prepare
2) bind
3) execute
that is allot of round trips;).
cheers
John Scoles
Owen wrote:
I have a sqlite (version 3.6.13) database with 30+ rows
1500 of these rows have faulty data.
So I read the main database row by row, tested the validity of one
column
version of DBD::Oracle I would like you to
rerun your code but this time do this
$dbd-{dbd_verbose}=15;
after you connect and then send me all the output from a test run of you .PL
cheers
John Scoles
Bob McGowan wrote:
Ok that is great that is all I need to go on.
The copy of the
append_comments
procedure would be good as I would be able to 'test' better with it
as long as you are comfortable with sending it to me
Cheers
John Scoles
On 05/26/2010 10:46 AM, John Scoles wrote:
Bob
Long answer No with a But!
Short answer Yes with a Maybe!
You are actully the first one to ask about it since I took over maintaining
DBD::Oracle 5 years ago. Here is my answer
1) Yes the article is old and well out of date (and very one sided as TD often
is no wonder he is going
Victor Churchill wrote:
The line you highlighted tells you that the make command failed
because it could not find a C compiler (cc: not found). This could be
because it's not present on your system, or because it can't be found
in your $PATH. The C compiler exists because it is detailed lower
have to use DMO or even SMO to get that kind of information
and that is well out of the scope of DBI/DBD
Are you using SQL server 05 or 08 or something older?
Cheers
John
Hi,
As Alex asked me why I not giving the name of the database in the
connection string, the script I writing
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 PTF.
to build DBD-Oracle, i had to hack the makefile slightly to remove a
bogus -q32 from the LD commands, this per the
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 PTF.
to build DBD-Oracle, i had to hack the makefile slightly to remove a
bogus -q32 from the LD commands
John R Pierce wrote:
ugh, the make test output came out unreadable, lets try again...
dang. one last time, and if this fails, I dunno whats going on, I'm
copy/pasting this from my ssh session into this email.
the important part is ...
t/58object.t 1/51 DBD::Oracle::db prepare
I know 1.24 and the latest trunk should work for RHEL5 and orcle 11g
From: a...@hotmail.com
To: dbi-users@perl.org
Subject: DBD oracle rhel5 11g R2
Date: Fri, 14 May 2010 21:46:15 +
any one has success in getting this working..
thanks
Srinivas.
on that;)
cheers
John Scoles
There is no such method in DBI, and as far as I know, there was never
one.
The only way to specify a database is to use the connect() method of
the DBI class.
Please help me on this.I work with microsoft sql server
2005.
What DBD do you use? DBD::ODBC?
Alexander
Bruce Johnson wrote:
Depends if you have |AutoCommit| on or not and if you DB and DBD friver
can do a rollback.
cheers
John Scoles
If $dbh is my database handle, to roll back the current transaction I
do: $dbh-rollback(); right?
The DBD::Oracle docs don't explicitly say
That is what I would say you would have to go with as I could not find a
C or C++ interface for it on my quick look at the site. There must be
one someplace though??
cheers
John
Alexander Foken wrote:
It doesn't seem so. But according to the web page you linked, h2 has
an ODBC driver, so you
for errors is there
comparable in SQLLDR??
Cheers
John
Cheers,
Parag
On Sun, May 2, 2010 at 5:27 PM, Jeffrey Seger j...@jeffseger.com
mailto:j...@jeffseger.com wrote:
I think you have to keep the time reading records and setting up the
arrays in the comparison, as SQLLDR has to read
On Sun, May 2, 2010 at 4:20 AM, Parag Kalra paragka...@gmail.com wrote:
Hi All,
I want to know which one of these algorithm would be the most optimized
solution to insert large number of records and Why:
1. Preparing an Insert query once and executing it with place holders for
the entire
but you are only testing the time it takes to
do the insert and not the time to set up the arrays??
cheers
John SColes
On Sun, May 2, 2010 at 7:44 PM, Parag Kalra paragka...@gmail.com wrote:
Ok here is the thing.
This afternoon I coded few scripts and created a test setup to validate
::Oracle 1.23 (or
possibly upgrade), possibly change the queries to use table functions (how?).
Our DBA suggested using set arraysize how do you do that from DBD::Oracle?
We have VARRAY(200) for our varrays.
Thanks!
John Carlson
cryo.sql
Description: cryo.sql
you seem to be the only one using varray would love to talk to you
off line n how you use them.
Cheers
John Scoles
From: carlso...@llnl.gov
To: dbi-users@perl.org
Date: Fri, 30 Apr 2010 16:12:20 -0700
Subject: speeding varray queries in DBD::Oracle
We have a lot of similar queries (see
This is a case of RTFM
http://search.cpan.org/~timb/DBI-1.611/DBI.pm#PrintError_(boolean,_inherited)
PrintError will just print the error and go on its merry way
From: paragka...@gmail.com
Date: Fri, 30 Apr 2010 12:39:38 -0700
Subject: How to discard the error in SQL query
To:
ranjith makineni wrote:
For DBD::Oracle and DBI you will need to get a copy of a Visual C++
compiler and nmake.
If you down load DBD::ORacle 1.24 and have a look at the README.win32 it
has full instructions on what you have to do.
You are better off using a later version of DBI than the
Looks like you are trying to 'run' a DBD::Oracle that was compiled against the
11.2 client against the 10.2 client??
Or the path to the 11.2 client is somehere in you enviornment perhaps the PATH
or the client .so files have permission setting that do not allow you to
execute them
It is somthing in you connection string or you do not have the TNS_ADMIN env
car set
TNS_ADMIN should point to your TNSNAMES.ORA file
Subject: Having a problem conneting to an Oracle 11gr2 RAC
Date: Thu, 29 Apr 2010 15:03:18 -0500
From: scott.stric...@ngc.com
To:
Royce Miller wrote:
I am taking over the Perl stuff for someone that was laid off. The previous
guy built Perl with CGI, DBI and DBD modules for use with a Informix database
and IBM IHS web server. He then tar'd it all up and copied it to a different
server and where thing do not all
Nothing to DBI or DBD oracle
Check your SQL statement you have only 52 '?' but you are trying to bind
field 53
cheers
John Scoles
Tim Bunce wrote:
- Forwarded message from Arshad Mahmood arshad.mahm...@manchester.ac.uk
-
Date: Mon, 26 Apr 2010 12:52:41 +0100
From: Arshad Mahmood
seen rates well into the 1s
for some other users
version 1.22+ fixed this by doing either an OCIPing if you are using 10+
client or another OCI call that does a round trip to the server.
Hope this helps
cheers
John Scoles
Matthew Maglinte wrote:
I'm a dba supporting a warehouse database
Leonard Cowan wrote:
I'm get this error :WARNING: Oracle build rule discovery failed (512). What is
this
usually means nothing what did the 'make' results show??
cheers
John
[r...@linux4 DBD-Oracle-1.24]# perl Makefile.PL
Using DBI 1.609 (for perl 5.012000 on i686-linux) installed
situations but do you
really want to catch code like this
$dbh-do('select * from v$session where 0=1');
which is not inline scripted but looks like it??
Anyway I have a good name for it
DBI-Nanny
cheers
John Scoles
Gabor Szabo wrote:
Hi,
I have just noticed a web application I am using has
Howard, Chris wrote:
Can you send the error message just for fun.
Cheers
John
I wasn't too clear.
The scripts give error message complaints, but they
actually do work.
Chris
-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Wednesday, April 21, 2010 12:39
Without DBI you are very limited in what you can do.
You might want to take a time machine back and give Oraperl a go
http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oraperl.pm
Old and unmaintained but at least I think you can run it without dbi
cheers
John
Hi all,
I need to convert a lot
No you are not missing 64k seems to be the limit for that interface with
Clobs and it is a Historical Oracle limit not Perl limit.
in DBD::ORacle 1.24
http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oracle.pm#Simple_Fetch_for_CLOBs_and_BLOBs
I say the following
For CLOBs and NCLOBs the
client. Do you know which Oracle client you are using??
Cheers
John Scoles
Subject: Problems with external password store.
Date: Mon, 19 Apr 2010 10:42:16 -0600
From: howa...@prpa.org
To: dbi-users@perl.org
I have two database servers, there are some differences
between the way
James Hooker wrote:
Thanks for the info John.
The following statement is the part confusing me:
However if you CLOB is longer than this and also larger than the
'LongReadLen' than the 'LongReadLen' in chars is returned.
Funny thing took me a while to figure this one out at well. Has to do
Yes you can find out with ORA_OCI
use DBD::Oracle qw(:ora_types);
print DBD::Oracle::ORA_OCI
I think will work
Cheers
John
Only one wallet is involved, and one connection.
The Oracle Client issue might be in play. I think
the case where wallet is not working right may
have been
::oracle should be ok but rather dated.
Cheers
John Scoles
Howard, Chris wrote:
As I suspected the one that doesn't work with wallet
is using Oracle 8.1.7.0 client.
I have some preparatory work to do before I can change that,
but I suspect it is the problem.
Chris
-Original Message
Bruce Johnson wrote:
On Apr 20, 2010, at 3:49 AM, John Scoles wrote:
Without DBI you are very limited in what you can do.
You might want to take a time machine back and give Oraperl a go
http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oraperl.pm
Old and unmaintained but at least I think
Would it be possible to install DBI DBD::Oracle in your home folder and test
there?
John
-Original Message-
From: pDale [mailto:pda...@gmail.com]
Sent: Monday, April 19, 2010 7:33 AM
To: newbie01 perl
Cc: beginn...@perl.org; dbi-users
Subject: Re: Help on using on *nix and Windows
or
libclntsh.so for lunix
So to solve it add the dir of your oracle client to your path.
Cheers
John Scoles
On Thu, Apr 15, 2010 at 8:23 PM, Leonard Cowan lhco...@bellsouth.netwrote:
make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl -MExtUtils::Command::MM -e
test_harness(0, 'blib/lib', 'blib/arch') t
Leonard Cowan wrote:
make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl -MExtUtils::Command::MM -e
test_harness(0, 'blib/lib', 'blib/arch') t/*.t
t/01base.t .. 1/6 # Test loading DBI, DBD::Oracle and version
# Failed test 'install_driver'
# at t/01base.t line 22.
Failed to load
Unless you are planning to use the 'Table' Datatype I would not worry much
about this one.
Will not effect 99.999% of any day to day use of DBD::ORacle unless like I
daid above you plan to make use of the
Oracle specific Object types, OBJECT, VARRAY, TABLE.
Cheers
John Scoles
Sounds more like an SQL problem to me.
The way you are doing that update is the most inefficient ways possible.
They doing this as one SQL statement with an Update select or Join rather that
select one subset and iterate over it to update another.
Anyway in you perl code
Martin Gainty wrote:
Hi Jeff-
the short answer is yes as Multi-threaded libraries are not same as
SingleThreaded library which usually spawn n number processes to achieve the
same goal for handling execution units
so if your perl script (assuming you'r running apache) is pegging the processor
Hard to say exatly are you sure you are connecting to oracle corretly??
use DBI;
my $dsn = 'DBI:Oracle:host=localhost;port=1527;sid=XXX';
is a rather odd dsn
I usually put
use DBD::Oracle;
after the DBI part.
Date: Wed, 31 Mar 2010 16:31:11 +0200
Subject: Perl
Yes
with ora_charset, ora_ncharset on the connection creation.
Remember like NLS_LANG you are setting the charsert of the client and not
the server.
On Thu, Mar 11, 2010 at 2:46 PM, E R pc88m...@gmail.com wrote:
Hi,
I'm using DBD::Oracle.
Is it possible to set the NLS_LANG setting on a
Date: Tue, 9 Mar 2010 08:42:28 +
From: martin.ev...@easysoft.com
To: byter...@hotmail.com
CC: john...@pharmacy.arizona.edu; dbi-users@perl.org
Subject: Re: DBI bind_param_inout question
John Scoles wrote:
Silly me you do need it so rare that I use it day to day.
In my case
Date: Tue, 9 Mar 2010 16:40:54 -0600
Subject: adding attributes to a database handle
From: pc88m...@gmail.com
To: dbi-users@perl.org
Two questions:
1. Is it possible to add/store user defined attributes in a database handle.
Yes
it is used to tell the DB how much memory to use.
As you are just getting a number you can just ingnore it
hope this helps
From: john...@pharmacy.arizona.edu
To: dbi-users@perl.org
Subject: DBI bind_param_inout question
Date: Mon, 8 Mar 2010 15:14:24 -0700
The syntax is $csr
@perl.org
From: john...@pharmacy.arizona.edu
To: byter...@hotmail.com
Subject: Re: DBI bind_param_inout question
Date: Mon, 8 Mar 2010 17:11:34 -0700
On Mar 8, 2010, at 4:52 PM, John Scoles wrote:
depends on the DBD::Driver implimentation.
In DBD::Oracle the maxlenth usually means
Great to hear a least I was helpful to someone.
cheers
I got it to work finally after a huge help from John Scoles.. I needed
the DBD:Oracle for 64 bit and needed to download a full version of
Visual Studio that had 64 bit compilers. It appears the Visual Studio
C++ express doesn't have
Would be great if one could jsut change the oracle hole like that and have it
work.
Unfortunetly we do not live in fairy-tale land so you will have to recompile
your DBD::Oracle against your new client.
cheers
John
To: dbi-users@perl.org
From: serguei.goumeni...@cibc.ca
Subject
Martin Evans wrote:
Most likely you are running into the problem of lob locater state
A lob field can have two states
1) Null meaning no Lob locater present
2) Lob Locater present (it might point to a null LOB of course)
You might try and change your code so that is tests for null in the lob
of DBD::Oracle are you using?
If you can upgrade to DBD::Oracle 1.22 (do not use 1.23 there is a bug
in there that might be worse) or get the latest 1.24 version
that might solve your problem
cheers
John Scoles
Matthew Maglinte wrote:
I'm a dba supporting a warehouse database (production
Uh. I just installed DBD::Oracle 1.23 with a patch. Should I install
DBD::Oracle 1.22 instead? What I the nature of the bug?
I am fairly new to the dbi-users group, and I haven't been watching the emails.
John
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent
The bug in 1.23 will hit you if you try to an insert more than one CLOB
at a time.
If you are not inserting CLOBs then do not worry about it.
Cheers
John Scoles
Carlson, John W. wrote:
Uh. I just installed DBD::Oracle 1.23 with a patch. Should I install
DBD::Oracle 1.22 instead? What I
So far, I am read only!
Thanks,
John
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 05, 2010 9:31 AM
To: Carlson, John W.
Cc: Matthew Maglinte; dbi-users@perl.org; tim.bu...@pobox.com
Subject: Re: dbd::oracle behavior
The bug in 1.23 will hit
should be no problem then what was the original version of DBD:Oracle
and DBI where you using??
So far, I am read only!
Thanks,
John
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 05, 2010 9:31 AM
To: Carlson, John W.
Cc: Matthew Maglinte
having trouble installing
DBD::Oracle 1.23, so we upgraded to DBI 1.609 and that seemed to fix the
problem.
What DBI and DBD::Oracle do you recommend for production use?
John
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 05, 2010 9:52 AM
that will speed up any queries you do by
a few orders of magnitude ;).
cheers
John Scoles
I was using DBD::Oracle 1.20 in development, and DBD::Oracle 1.21 in
integration, test and production. So far we have only deployed DBD::Oracle to
development. Would you recommend to install something else
There is a problem with that file. It looks like it's compressed twice.
John
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 05, 2010 10:07 AM
To: Carlson, John W.
Cc: Matthew Maglinte; dbi-users@perl.org; tim.bu...@pobox.com
Subject: Re: dbd
a trace file was generated at
failure time.
cheers
John Scoles
Lopez Mariz, Luis Fernando wrote:
Apreciate your help thans a lot
Luis Fernando Lopez Mariz
CATE GE - Enterprise Access Engineering
52 (55) 22620675
Red Banamex 50675
-Original Message-
From: Michael Nhan [mailto:mn
Would this help? Note the precision on the timestamp.
CREATE OR REPLACE TYPE ARCHIVE.VOLTAGE_TIMESTAMP_ARRAY AS VARRAY(200) OF
TIMESTAMP(6);
From: John Scoles [mailto:byter...@hotmail.com]
Sent: Thursday, January 28, 2010 5:04 PM
To: Carlson, John W.; dbi-users@perl.org
Subject: RE: selecting
digits on a
timestanmp they are simply not returned by the object handler.
cheers
John Scoles
Carlson, John W. wrote:
Would this help? Note the precision on the timestamp.
CREATE OR REPLACE TYPE ARCHIVE.VOLTAGE_TIMESTAMP_ARRAY AS VARRAY(200) OF
TIMESTAMP(6);
From: John Scoles [mailto:byter
Yes, I have patched DBD::Oracle 1.23 and it's working! Thanks a bunch!
It was only changing the 0 to a 6, right?
The reason I was trying to patch it another way was because I don't have root
on the machine in question.
John
-Original Message-
From: John Scoles [mailto:sco
.
Thanks,
John Carlson
+1 for '\0'
do you need more accuracy than that??
Looking into the code I see that we do not supply a
fsprec (IN) value that Specifies the precision in which the fractional seconds
is returned. not sure it this is what is effecting you
Cheers
John Scoles
Thanks,
John Carlson
_
You can find it here
http://search.cpan.org/~pythian/DBD-Oracle-1.19/
- Forwarded message from Prindle, Douglas E
douglas.e.prin...@citi.com -
Date: Tue, 26 Jan 2010 17:03:33 -0600
From: Prindle, Douglas E douglas.e.prin...@citi.com
To: 'tim.bu...@pobox.com' tim.bu...@pobox.com
CC:
Up we are using it right now with no real problems.
Will need to know what you are trying to do
You can now use MS Visual C++ 2008 express edition 'right our of the
box'
to do the build and compile and install
cheers
John
TAYLOR, DANIEL L (ATTSI) wrote:
I am having issues trying
Agarwal, Gopal K wrote:
Hi All,
Aplogies for the ambiguous question below. I'll explain it further.
I am writing the perl program which will analyze the Data Base
performance across different vendors. The amount of data is in orders of
Giga Bytes.
I want to select the data from table and
us the version of DBI, DBD::Oracle, Oracle and a small
example of the code where you are having the problem??
cheers
John
Hi,
I am connecting the Oracle DB with perl DBI. For short queries
(execution time 2 sec) I am able to fetch the data but for long
queries (7 sec) my perl scripts hangs
and a
RowsToFetch
that would tell the server how many rows to get at a single fetch??
Most SQL servers can to this now if I am not mistaken?
cheers
John Scoles
Hi,
I was attempting to check DBD::Oracle 1.24 rc1 fixed the issue
RowCacheSize is being ignored slowing down fetches a lot,
http
leave it running with 1.17.
The above aside update DBD::Oracle might work if you set the
ORACLE_HOME, LD_LIBRARY_PATH, correctly have the same C compiler that
built your perl.
cheers
John Scoles
201 - 300 of 919 matches
Mail list logo