Hi Jonathan,
Silly question time - I assume that if you don't includes the DBI-connect
line, then the two invocations of showbin produce the same output in both
versions of Perl.
It does. And in that case, the only float representation obtained is:
Hi Tim!
Ah, now it's getting interesting! :)
So I thought :)
Are the two versions of DBD::Oracle built against the same Oracle
version/installation?
No.
The one used by perl 5.6.2 was built against an oracle 9.2.1.0 (unsure
of the exact version, but it was a 9.*). The one used by perl
Take a look at the source for the Perl_sv_2nv() function in sv.c
in the two distributions.
Also check for differences in the perl config
items that impact that code.
Back from a first dive.
There are significant differences between 5.6.2 and 5.8.8 with respect
to how PVs are translated to
hu.darren wrote:
Hi,
I have installed the DBD::ODBC from the latest svn.
when I want execute a procedure like this:
my $whoami = ;
my $csr = $dbh-prepare(q{
BEGIN
:whoami := PLSQL_EXAMPLE_DARREN.FUNC_NP;
END;
});
I presume since that
Erwan Lemonnier wrote:
Hi Tim!
Ah, now it's getting interesting! :)
So I thought :)
Are the two versions of DBD::Oracle built against the same Oracle
version/installation?
No.
The one used by perl 5.6.2 was built against an oracle 9.2.1.0 (unsure
of the exact version, but it was a 9.*).
perl --version
This is perl, v5.8.8 built for i486-linux-gnu-thread-multi
select * from v$version
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL
On Wed, Jul 18, 2007 at 10:23:52PM -0700, Theron Stanford wrote:
Overview: I'm trying to create the situation in the subject line:
from the outside, the database handle thinks it's just one database,
but inside it's really two databases containing tables with the same
schema but not
Well maybe it is time if piped up.
I ran the code in x.pl as well and just to add some more fuel to the fier I
ran it in activestate perl on a windows XP box.
I will try it on some different boxes as well
Here are my results
C:\johns\testperlperl x.pl
bin:
Here is the test again. Same DB and same version of DBI, DBD::Oracle and
the Oracle client but this time on a Lunix box
[EMAIL PROTECTED] wwwtest]$ perl x.pl
bin: 0011100010101001011010010001101001110101110011010001
connecting
bin:
Hi,
What about a round robin dns for the database server? Connect to the
server via a dns name that can be round robin to 2 ips. One per database
server. The outside host wouldn't know the difference and would simply
connect to the dns name and external ip that it was given and your inside
On Thu, 2007-07-19 at 09:42 +0200, Erwan Lemonnier wrote:
Hi Tim!
Ah, now it's getting interesting! :)
So I thought :)
Are the two versions of DBD::Oracle built against the same Oracle
version/installation?
No.
The one used by perl 5.6.2 was built against an oracle 9.2.1.0
On Thu, 2007-07-19 at 09:36 -0500, Scott T. Hildreth wrote:
On Thu, 2007-07-19 at 09:42 +0200, Erwan Lemonnier wrote:
Hi Tim!
Ah, now it's getting interesting! :)
So I thought :)
Are the two versions of DBD::Oracle built against the same Oracle
version/installation?
No.
Hi all!
I have started a thread on perl5-porters discussing the same issue.
The posts are not yet archived on
http://www.nntp.perl.org/group/perl.perl5.porters/ but should appear
there quite soon.
What this new thread boils down to (so far) is that perl 5.6 uses the
native atof to convert from
Robert Hicks wrote:
Paul DuBois wrote:
snip
Tim, thanks for clarifying.
I was wondering because it wasn't clear to me, in writing about DBI,
how to
characterize what version of Perl a reader should have. I'll write that
5.6.0 is required but 5.6.1 is preferred.
What are you writing about
Paul DuBois wrote:
snip
Tim, thanks for clarifying.
I was wondering because it wasn't clear to me, in writing about DBI, how to
characterize what version of Perl a reader should have. I'll write that
5.6.0 is required but 5.6.1 is preferred.
What are you writing about DBI? ; )
Robert
Thanks to all, and apologies to all.
I should have waited another day to flesh this out before sending, but
I was trying to take advantage of living on the west coast of the USA
to send this out last night and come to work this morning to find my
inbox teeming with lots of interesting ideas.
I would consider setting up the test database to consist of a database
link to the real database, along with views for all the tables.
Then on those tables where I wanted to interject some data, I would
create test-data tables and alter the views to merge the data.
Then switching from test to
This sounds like a good idea. I guess I just don't know enough about
databases yet to know how to do this linking. Mostly I just know
about how to get DBI to interact with MySQL.
I should mention that I'd also like to be able to make some rules in
the real database temporarily disappear while
And unfortunately I don't know enough about MySQL to be more helpful.
Database links may be an Oracle-only thing.
On 7/19/07, Theron Stanford [EMAIL PROTECTED] wrote:
This sounds like a good idea. I guess I just don't know enough about
databases yet to know how to do this linking. Mostly I
Hi Gurus,
I need your help. I am using active perl 5.8.8, windowsXP second edition. I am
trying to access an old app by using perl and odbc. I created a system DSN in
ODBC data source administrator and I tested by using crstal report writer.
Things are fine. I use DBI (1.58 dbd-odbc is 1.13)
Samuel_Zheng wrote:
Hi Samuel
CPAN says: http://search.cpan.org/~janpaz/DBD-XBase-0.241/
I use this module successfully.
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/
21 matches
Mail list logo
