Oracle 10G and perl v5.8.0

2007-02-15 Thread Krishnan, Vijaya
Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an upgrade to perl 6 would be required. Thanks, Vijaya Vijaya Krishnan Commercial / Government Card Technology and Payment Services Treasury and Payments Services (TPS) Technology Ph:704-683-0881(W);704-841-4358(H)

Re: DBD::Informix and SELECT from MULTISET column

2007-02-15 Thread tvilliers
On 23 Sep 2005, 16:23, [EMAIL PROTECTED] wrote: I'm looking for a bit more information WRT the returned dataset from selecting from a MULTISET column in Informix please. Create a small table: create table test (col1 int,col2 multiset(int not null)) and insert a couple of rows of test data

Re: DBD::Informix and SELECT from MULTISET column

2007-02-15 Thread Jonathan Leffler
I've been trying to wrap my brain around it (pretty casually, I admit) for a decade or so. If you'd like to help out with some code changes, I'm very willing to accept them. ...more below... On 2/15/07, tvilliers [EMAIL PROTECTED] wrote: On 23 Sep 2005, 16:23, [EMAIL PROTECTED] wrote: I'm

RE: Oracle 10G and perl v5.8.0

2007-02-15 Thread Garrett, Philip \(MAN-Corporate\)
Krishnan, Vijaya wrote: Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an upgrade to perl 6 would be required. They're compatible. I'd recommend using the latest stable version of Perl, though -- 5.8.8. (Perl 6 is not released yet...) Philip

DBD::Oracle - problem with UTF-8 charset and Oracle 8.1.7

2007-02-15 Thread Peter J. Holzer
I think I've reported that problem before but we didn't get close enough to fix the problem, so I'm taking another stab at it. Environment: Oracle server is 8.1.7. Oracle client is 9.2 (same problem with 10g) DBD::Oracle version 1.18 LANG=en_US.UTF-8 NLS_LANG=.UTF8 When a parameter has the

Re: Oracle 10G and perl v5.8.0

2007-02-15 Thread Kevin Spencer
On 2/14/07, Krishnan, Vijaya [EMAIL PROTECTED] wrote: Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an upgrade to perl 6 would be required. Perl 6 has not been released yet ;-) FWIW, I'm using 10G with 5.8.8 and everything plays nicely together. -- Kevin.

Re: DBD::Oracle - problem with UTF-8 charset and Oracle 8.1.7

2007-02-15 Thread Alexander Foken
http://search.cpan.org/~pythian/DBD-Oracle-1.19/Oracle.pm#Oracle_and_Unicode says roughly that Oracle 8 and Unicode don't mix well. If possible, try to upgrade the Oracle server to at least 9.2 and use AL32UTF32 as charset. (I'm not an Oracle expert. I'm just using it occasionally.) Alexander

Re: DBD::Oracle - problem with UTF-8 charset and Oracle 8.1.7

2007-02-15 Thread Peter J. Holzer
On 2007-02-15 18:45:31 +0100, Alexander Foken wrote: http://search.cpan.org/~pythian/DBD-Oracle-1.19/Oracle.pm#Oracle_and_Unicode says roughly that Oracle 8 and Unicode don't mix well. | Oracle 8 client libraries have a number of bugs related to character | set handling, especially when

RE: Oracle 10G and perl v5.8.0

2007-02-15 Thread Reidy, Ron
But, what do you mean by compatible? AFAIK, Perl 6 is not even close to being out yet. If it is, then you would need to use the DBI and DBD::Oracle for Perol 6 (I am very sure they will be different). I use Perl 5.8.* and Oracle 8.1, 9.2, 10.1, and 10.2 w/o issue. -- Ron Reidy Lead DBA Array