Re: getting problem while installing DBD-Oracle-1.19

2008-05-29 Thread John Scoles
We need to know what you are compiling against. Would you please post the results of your Makefile.PL?? Thie error can happen in a nuymber of ways Cheers John Scoles [EMAIL PROTECTED] wrote: Hi, When I tried to install DBD-Oracle-1.19 then I m getting below error in make test step

Re: Perl - connecting to Oracle

2008-05-21 Thread John Scoles
understood Mike to be flagging staion_id as the probable typo (hence ORA-00904), not *. Paul http://tardate.blogspot.com On Wed, May 21, 2008 at 5:00 PM, Tim Bunce [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: On Tue, May 20, 2008 at 07:44:33PM -0400, John Scoles wrote: No the * is DBI

Re: Perl - connecting to Oracle

2008-05-21 Thread John Scoles
I guess I can get that in for 1.22 Cheers John Scoles Tim Bunce wrote: Nevertheless, I've seen several instances of people not understanding that the * was added to the statement by DBD::Oracle as a marker when it reports the error. Changing it to something unambiguous would help. Tim

Re: Building DBD::Oracle on XP w/ VC 2005

2008-05-08 Thread John Scoles
Seem I now have access to an Oracle 11 box so I can have a look into this. So far I get the same results as you. Tomorrow I will have to do some debugging with this. Cheers John Scoles John Scoles wrote: I will CC this one to a contact I have at Oracle as the first question Oracle suport

Re: Building DBD::Oracle on XP w/ VC 2005

2008-05-01 Thread John Scoles
Can you point it to a different non 11 DB instance?? and run the tests again? Could be a bug on the oracle side? seems to be a number of them on 11 64 dbs coming up the past few days. cheers John Scoles Gerber, Christopher J wrote: Odd Gerber, Christopher J wrote: First off, I am new

Re: Building DBD::Oracle on XP w/ VC 2005

2008-05-01 Thread John Scoles
I will CC this one to a contact I have at Oracle as the first question Oracle suport will as is what it DBD::Oracle??? followed by we don't support it. If you do follow up say the execute array dose not work as expected. and that it works in 9. cheers John Scoles Gerber, Christopher J

Re: Error - DBD::Oracle / ORA-1008 problem with placeholders

2008-04-30 Thread John Scoles
not be the first time that they had a bug in their code. For now I might add this to the Readme cheers John Scoles . [EMAIL PROTECTED] wrote: Hello John, Please find the table definition : create table owner1.table1 ( col0CHAR(8) not null, col1

Re: Error - DBD::Oracle / ORA-1008 problem with placeholders

2008-04-29 Thread John Scoles
Can you give me what the table schema is? I would like to know what datatypes col1,col2,col3,col4 are so I can try and recreate the error. As well what operation system are you using and which version of DBI? anyway just looking at the SQL it doesn't look quite right cheers John Scoles

Re: DBD::Oracle and Support for Oracle 8 and 9 clients

2008-04-18 Thread John D Groenveld
/collateral/lifetime-support-coverage-chart.pdf That's not a cry for DBD::Oracle support moving forward as I'm mostly dealing with more recent Instance Client. John [EMAIL PROTECTED]

Re: Log DBI query and values with placeholders

2008-04-15 Thread John Scoles
I would have to agree with Martin that DBIx::Log4perl will work quite well. In the long term you might want to accomplish this by adding some triggers on your DB tables to record this data as well. This way all changes to the table will be caught at the DB end. So in cases where someone is

Re: Urgent help required : Issue with DBD:Oracle 1.20 installation

2008-04-04 Thread John Scoles
oracle client use an older DBD::Oracle. You can also compile you DBD:Oracle against the Oracle instant client and it will work as well cheers John Scoles Divyansh Nasa wrote: Hi all I am trying to install DBD-Oracle-1.20 downloaded from CPAN. I am getting the following errors. Request you

wrong ELF class:

2008-04-01 Thread Moon, John
/DynaLoader.pm line 230. at (eval 3) line 3 Compilation failed in require at (eval 3) line 3. Perhaps a required shared library or dll isn't installed where expected at ./test_dbi.pl line 50 script full output below... John W Moon #! /usr/local/bin/perl -W use lib $ENV{HOME}/local/library; BEGIN

RE: wrong ELF class:

2008-04-01 Thread John Scoles
in require at (eval 3) line 3. Perhaps a required shared library or dll isn't installed where expected at ./test_dbi.pl line 50 script full output below... John W Moon #! /usr/local/bin/perl -W use lib $ENV{HOME}/local/library; BEGIN { $x=0; foreach $b (@INC) { print \$INC[$x] = $b\n; $x

Re: question for DBD-Oracle driver

2008-03-28 Thread John Scoles
give this a try #!perl -w use DBI; use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI().\n; if you dbi is 1.47 you can use up to DBD::Oracle 1.19 cheers John Scoles [EMAIL PROTECTED] wrote: Dear sir/madam, How can we tell that we have already install DBD-Oracle drive

Re: question for DBD-Oracle driver

2008-03-28 Thread John Scoles
will have to install it with CPAN or alike Cheers John Scoles give this a try #!perl -w use DBI; use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI().\n; if you dbi is 1.47 you can use up to DBD::Oracle 1.19 cheers John Scoles [EMAIL PROTECTED] wrote: Dear sir/madam, How

Re: perl DBI oracle and error ORA 06502

2008-03-20 Thread John Scoles
You might want to set the DB handles LongReadLen attribute to a higher values say 100 meg like this dbh-{LongReadLen} = 100*1024*1024 and then give it a try, That might work for you. Cheers John Scoles John Scoles wrote: It could be in perl but if this is the case I would need the exact

Re: What causes this 32 bit problem??

2008-03-20 Thread John Scoles
. and I think they should not be running in 64bit mode of course I could be wrong on this. I have never looked into it. Sorry I cannot be more help to you Cheers John Scoles Richard T Malafa wrote: John, I've tested your DBD::Oracle 1.20 against both PA-RISC and Itanium Machines with the 32 bit

Re: perl DBI oracle and error ORA 06502

2008-03-19 Thread John Scoles
would first have a look at your data looks like there is something in the PSQL of the packge dbms_output_get that is giving you the error. In this case DBI and DBD::Oracle are simply working as they should returning an error message from the database. cheers John Scoles Pompiliu wrote: Hi

Re: Google SoC: Fame and Fortune ($4500) await you!

2008-03-19 Thread John Scoles
Yep sounds like a good Idea and I have been using Memcached for aout two years now with DBD::Oracle but not in the way you are looking at it. I can offer my help as well but you might want to look at DBI::Gofer as I think Tim's plan was to make that compatible with memcached Cheers John

Re: perl DBI oracle and error ORA 06502

2008-03-19 Thread John Scoles
way to see where it dies. Again I do not hold out much hope for this as it is a Oracle error that is being returned not a DBI/DBD one. I would also need the name of and version your OS, perl, DBI, DBD::Oracle, The Oracle client you are running and the Oracle DB itself cheers John Scoles

Re: Library not found errors with DBD-Oracle-1.20

2008-03-18 Thread John Scoles
this when you la -a libclntsh.so - libclntsh.so.10.1 Just a thought cheers john scoles James H. McCullars wrote: Hi, I have successfully installed the Oracle instant client, DBI-1.602 and DBD-Oracle 1.20 and can connect to a database on a remote host, but only if I set LD_LIBRARY_PATH

RE: Accessing Remote LOBs in Oracle

2008-03-06 Thread John Scoles
writing it youself but OCI is not something you can pick up in 5min. I been working in it for two years now and I still know nothing. cheers John Scoles From: [EMAIL PROTECTED] To: dbi-users@perl.org Subject: RE: Accessing Remote LOBs in Oracle Date: Wed, 5 Mar 2008 16:19:42 -0600 I'm barely

Re: Accessing Remote LOBs in Oracle

2008-03-06 Thread John Scoles
What I am going to need is some detailed code examples of what you want to do. SQL, DATA perl examples etc and of course the SQL to generate the tables fields etc. If you are using the 10.2.0 client that should be the same version as in you link and should be able to do it. There are some

Re: Using to_dsinterval or INTERVAL with placeholder

2008-02-12 Thread John Scoles
Well maybe DBD::Oracle dose not know how to bind them, Set the debug to 15 before the prepare statement and off after the binds and lets see what you get. these are very obscure Oracle types so I could see that they may not work. cheers John Scoles Vanole, Mike wrote: Thanks Joseph, I

RE: I want to install couple of package in my windows machine.

2008-02-09 Thread John Scoles
Best to use Active state perl and thier PPM program. Quick free and easy to use. Subject: I want to install couple of package in my windows machine. Date: Fri, 8 Feb 2008 18:32:10 +0530 From: [EMAIL PROTECTED] To: dbi-users@perl.org Hello, Here I am using windows operating system

RE: DBD-Oracle 1.20 - problems compiling on Windows (Visual Studio 2005 Perl 5.10)

2008-02-02 Thread John Scoles
Unfortunately that would be unlawful. Oracle does not allow 3rd parties to bundle their software. Check out the Readmewin.txt it has a very good tutorial on how to compile for windows. Subject: DBD-Oracle 1.20 - problems compiling on Windows (Visual Studio 2005 Perl 5.10) Date: Fri, 1

Re: DBI-DBD::ORACLE EROR

2008-01-29 Thread John Scoles
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

Re: DBI-DBD::ORACLE EROR

2008-01-29 Thread John Scoles
at the README.linux.txt and try some of the suggestions there as well cheers John Scoles Mohammed, Shafi wrote: Hello , Now I want to use DBI for my current project. Here I have trying to install DBD::ORACLE PACKAGE it is thronging error. And it is now allowing to install this package

Silly Question

2008-01-28 Thread John Scoles
Who is the current maintainer of DBD::MySQL??

Re: Silly Question

2008-01-28 Thread John Scoles
Ok Thanks for that, Cheers John Scoels Patrick Galbraith wrote: John Scoles wrote: Who is the current maintainer of DBD::MySQL?? John, I am. regards, Patrick

Re: Oracle procedure raises exception but looks to be successful from DBI

2008-01-25 Thread John Scoles
wrote: John Scoles wrote: Wow I go one right for once. Not 100% sure on why that is? Me thinks when you use 'Begin End' it forces OCI to take it as an pseudo 'stored procedure' and runs in the current OCI client. I think using call just executes as a thread off the present client

Re: Oracle procedure raises exception but looks to be successful from DBI

2008-01-25 Thread John Scoles
?? You might want to try 'exec proctest(?); ' I think it does it in the local client. Will have to crack open the OCI docs to see and as I am not suffering from insomnia right now I have no real want to start digging though it right now. Cheers Martin Evans wrote: John Scoles wrote

Re: Oracle procedure raises exception but looks to be successful from DBI

2008-01-25 Thread John Scoles
That is an odd one, I will check with the DBAs here to see if this is normal Oracle behavior Well the error id correct but and on my box an error is thrown that I catch I did change my code over to begin track.proctest(?) end; what version of DBI and DBD are you using?? cheers Martin

Re: Does changing ORACLE_HOME affect DBI?

2008-01-18 Thread John Scoles
in sync I would recompile. That being said once DBD::Oracle is compiled is should be somewhat stand alone and not rely on the oracle client directly anymore. So changing the the Home shouldn't matter. Cheers John Scoels RICHARD FERNANDEZ wrote: Hello folks, A while back (months and months

Re: Which versions to use

2008-01-11 Thread John Scoles
::Oracle binary 1.16?? which could work for you. Cheers John Scoles COUPRIE Kees wrote: So finally, after struggling with DBD 1.48 and DBI-Oracle 1.12 for some time, I now have permission to upgrade to newer versions. Newby question: which versions should I use. Is it advisable to use the latest

Re: Using q() to define a query

2008-01-11 Thread John Scoles
I beleive most SQL parsers will ignore white space like that in an SQL query. Normally single quotes in parameters are the bug bear of the the SQL programmer, ie select name,rank,ser_no from sailors where name = O'Tool It is alway good practice to use parameterized queries instead that you

RE: Segmentation Fault(Core dumped)

2008-01-08 Thread John Scoles
@perl.org; [EMAIL PROTECTED] John/All, Can you pls share steps to re compile the DBD::Oracle module. we have perl 5.8.6 installed on separate path and I am not using the libraries under the oracle client (10.2.0) installation. Can you pls let me know how I can recompile DBD module from its path

ANNOUNCE: DBD::Oracle 1.20 Release Candidate 8

2008-01-07 Thread John Scoles
In an effort to broaden the testing base I would like as many of you out there to give a try at installing and running http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.20-RC8.tar.gz So far we think we have most of the problems ironed out but we still need a larger test pool as this

RE: Segmentation Fault(Core dumped)

2008-01-07 Thread John Scoles
in speed (or anything else for that matter really) in updating the Oracle drivers. John Scoles Subject: RE: Segmentation Fault(Core dumped) Date: Mon, 7 Jan 2008 16:51:58 + From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: dbi-users@perl.org; [EMAIL PROTECTED] Martin, I have executed

RE: Environment variable problem?

2007-12-19 Thread John Scoles
season.Sam On 12/18/07, John Scoles [EMAIL PROTECTED] wrote: Looks like a simple permissions error. 1) check to ensure you have libclntsh.so.10.1 on you computer (This is an oracle client) if not then you will most likely have to recomple your DBD::Oracle against whatever Oracle client you wnat

Re: Oracle connection issue with perl DBI

2007-12-19 Thread John D Groenveld
/oracle/9.2.0.8 /opt/bin/oracle/9.2.0.8/bin/sqlplus euser/epas@'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.gold.com)(PORT=1522))(CONNECT_DATA=(SID=sid)))' If not, contact your DBA. John [EMAIL PROTECTED]

RE: Connecting to Database

2007-12-08 Thread Moon, John
Sent: Friday, December 07, 2007 8:52 AM To: dbi-users@perl.org Subject: Connecting to Database Hello At the present time I am using Perl, cgi, Apache Web Page, SQL, and SYBASE database on a unix server(SUN Fire V 880). I have no problem accessing the Sybase database, fetching records and

Re: Fun with UTF-8 and Oracle [PATCH]

2007-12-05 Thread John Scoles
Thanks for that I will include that in the release and in the next RC Peter J. Holzer wrote: On 2007-09-04 14:20:20 +0100, Tim Bunce wrote: On Mon, Sep 03, 2007 at 07:20:42PM +0200, Peter J. Holzer wrote: On 2007-09-03 13:03:37 +0100, Tim Bunce wrote: Oh the joys of Oracle

RE: compatibility matrix

2007-12-05 Thread John Scoles
Well of the top of my head no. But here is my 2cents DBI and DBD::Oracle 1.19 should be compatiable with any version of Oracle going right back to 7. It is more a matter of which Oracle Client you complile DBD::Oracle against. Basically any new client should be able to connect to an older

RE: New edition of the Cheetah?

2007-12-01 Thread John Scoles
Maybe you can time it to come out at the same time as Perl 6?? From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: dbi-users@perl.org Subject: RE: New edition of the Cheetah? Date: Fri, 30 Nov 2007 14:03:49 -0700 Jeff, Thank you for your reply. I have taken the liberty of fleshing out your

RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

2007-11-29 Thread Moon, John
-Original Message- From: BAIER, ANTHONY (TONY), ATTSI [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 11:06 AM To: STILWELL, DAVID B (DAVE), ATTLABS; dbi-users@perl.org Subject: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my

Re: Issue with perl, DBD::Oracle, Solaris 10

2007-10-29 Thread John D Groenveld
://developers.sun.com/sunstudio/index.jsp I recommend that the OP build his own Perl from source for his application regardless which compiler he uses. John [EMAIL PROTECTED]

Re: Ref:-- How to transfer DBI/DBD binary.

2007-10-26 Thread John D Groenveld
libraries need to be the same version on both. What about the Perl??? Is that also have to be identicial in every respect??? I assumed the OP is planning on copying the entire Perl installation to the production machine. Has this actually been tried Yes. John [EMAIL PROTECTED]

Re: Ref:-- How to transfer DBI/DBD binary.

2007-10-25 Thread John D Groenveld
should be able to package up or tar your Perl build and extract it on your production server. Don't alter your Perl basedir and make certain your Oracle client libraries are in the same ORACLE_HOME on both systems. John [EMAIL PROTECTED]

Re: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly

2007-10-10 Thread John Scoles
Looks like the 64 bit perl vs 32 bit .pms issuesthat is croping up more and more. So I would go back one more step at remove all the DBI and get the source and recompile and insall. the DBD::Oracle again. What you might want to try is Not sure what the cure for this is?? Peter McLarty [EMAIL

Repost from CPAN DBD::ORacle forum

2007-10-10 Thread John Scoles
Hi. Sorry if this turns out to be a newbie mistake, but I've run into an odd problem while using DBD::Oracle. For some reason, my sql statement results in empty strings. Instead of getting the value i want to see there is a '', (please see below). The amount of columns (6 in this case) are

Re: DBD::Oracle 1.19 fails to find Oracle version, problem and solution

2007-09-27 Thread John Scoles
Yes it is a rather delicate subject as if we make it work for one it will break for everyone else. The real root of the problem is that Oracle in its divine wisdom has compacted all the .so files into one so there is no way you c compiler can get them but of SQL on the Ubuntu Server it could

Re: DBD::Oracle 1.19 fails to find Oracle version, problem and solution

2007-09-27 Thread John Scoles
Ok Martin we can pick this up on the morrow. I will add a few debug extra debug stuff about the Makefile and get you email me the results directly. Talk to you tomorrow Cheers John Scoles Martin Evans wrote: John Scoles wrote: Yes it is a rather delicate subject as if we make it work

Re: compiling DBD module on system with multiple versions of oracle

2007-09-13 Thread John Scoles
on the same box but I wount go into them here. cheers John Scoles

Re: DBD-Oracle Connection Problem

2007-09-13 Thread John Scoles
Hate to say this but if you can connect in any manner it is not really a DBD::Oracle problem. It is an Oracle problem of some sort. Unfortunetly this sort of problem (can be a real bugger to pin down. It could be anything from the way you have your listener setup to the way your

Re: DBI with different versions of Oracle

2007-09-11 Thread John Scoles
be more an Oracle bug than anything else. Hope this helps John Scoles - Original Message - From: Richard Labutis [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Tuesday, September 11, 2007 11:43 AM Subject: DBI with different versions of Oracle when building the module, you have

Re: DBI with different versions of Oracle

2007-09-11 Thread John Scoles
Looking at this again. If you have mulitple ORACLE_HOMEs in you path it is anyones guess as to which client your DBD::Oracle with compile against. In Lunix I have see the last one on the list be the one. Your best bet would be to change the ORACLE_HOME to the client you want to compile against

Re: DBI with different versions of Oracle

2007-09-11 Thread John Scoles
be no real issues with DBD::Oralce an connecting to different versions of Oracle. Cheers - Original Message - From: Richard Labutis To: John Scoles Sent: Tuesday, September 11, 2007 1:41 PM Subject: Re: DBI with different versions of Oracle I have found in the previous version

Re: TWO_TASK environment variable

2007-09-06 Thread John Scoles
isn't TWO_TASK only used when you have SQL*NET installed?? I do not think Instant-client installs that?? I will get onto one of my Oracle DBA types later to day and ask that. Might have to change the POD a bit to reflect that - Original Message - From: Martin J. Evans [EMAIL

Re: report (problems compiling DBD::Oracle on Solaris 10)

2007-09-05 Thread John Scoles
Looks like you are trying to compile the 32 bit oracle client with 64 bit system. I think you have to use the 64 bit oracle client. - Original Message - From: toni garcia [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Wednesday, September 05, 2007 10:56 AM Subject: report (problems

Re: Another set of DBI docs

2007-08-28 Thread John McNamara
. It looks quite good. pod2wiki --style tiddlywiki DBI.pm DBI.txt John. --

RE: Please take a moment...

2007-08-06 Thread John Costello
From the Perl Foundation's main page, http://www.perlfoundation.org/: 'Kirrily's goal is to take a snapshot of the Perl world as it currently stands. As an active member of the Perl community, she's often asked questions about Perl's users and is only left to hypothesise, generalise, and

Re: error on a windows 2003 serv er

2007-08-03 Thread John Costello
, or elsewhere? What are the permissions on the folder where the Access97 database resides? This sounds less like a perl/dbi issues and more like a Windows configuration issue. John

Re: Guidance on setting up multiple database handles to be used in one script

2007-08-01 Thread John Costello
to share the $dbh between processes. I'm still looking at DBI::Gofer, and can't say with confidence that it would work for this situation. John

Re: Slides of my DBD::Gofer talk at OSCON

2007-07-29 Thread John Costello
the full Gofer talk (though I caught your lightning talk). I appreciate having the chance to look over the slides. John

RE: datatype error

2007-07-27 Thread Moon, John
-Original Message- From: Craig Metzer [mailto:[EMAIL PROTECTED] Sent: Thursday, July 26, 2007 6:36 PM To: dbi-users@perl.org Subject: datatype error I'm getting an error trying to run an insert action due to the DATE or DATETIME datatype. I couldn't find anything on it, and was

Re: [DBD::Oracle] Familiar error to someone?

2007-07-20 Thread John Scoles
Itanium could be a 32/64 bit problem did you compiled all your code useing 32 bit libs? - Original Message - From: Robert Hicks [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Friday, July 20, 2007 8:03 AM Subject: [DBD::Oracle] Familiar error to someone? We have a mixed C/Perl/XS

Re: float bug? perl 5.8, DBI and oracle 10.2.0

2007-07-19 Thread John Scoles
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:

Re: float bug? perl 5.8, DBI and oracle 10.2.0

2007-07-19 Thread John Scoles
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 . [EMAIL PROTECTED] wwwtest]$ - Original Message - From: John Scoles [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Martin Evans [EMAIL PROTECTED] Cc: dbi-users@perl.org Sent: Thursday, July 19

Re: Re: float bug? perl 5.8, DBI and oracle 10.2.0

2007-07-11 Thread John Scoles
, NUMBER(38),TINY_INT and god knows what else. Cheers John Scoles Rutherdale, Will [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I admire Peter's effort in tracking down the specifics at various conversion points. However, there are no documented guarantees of equality from

Re: DBI-Help

2007-07-09 Thread John Scoles
Look like someone changed the access DB itself. If memory serves me corect there are setting in Access that can prohibit remote usage. I would try creating a new Access DB just to test to see if you can connect with it. Also you may have to do some configuration with IIS to get it to server

Re: Error while installing odbc.pm

2007-07-08 Thread John Costello
On Sun, 8 Jul 2007, Ron Savage wrote: Rohini Krishnan wrote: Hi Rohini E:\Perl\DBD-ODBC-1.13perl makefile.pl Ahh, Windows. Ahh, yes. E:\Perl\DBD-ODBC-1.13make Err, you have to use nmake or dmake under Windows, right? Probably. There is GNU Make for Windows,

Re: DBD::Oracle using 64bit oracle libraries

2007-07-06 Thread John Scoles
common problem one I will fix as soon as I get a 64 bit box here is some readme stuff the might pooint you in the right direction In general compiling DBD:Oracle for 64 bit machines has been a hit or miss operation. The main thing to remember is you will have to compile using 32 bit Perl and

Re: problems inserting a utf8 timestamp with DBD::Oracle

2007-07-05 Thread John Scoles
I think the key is Oracle client 9.2.0.4.0 with Oracle server 9.2.0.7.0, 10.2.0.3.0 seems this only pepps its head up when using this combination can you recreate it using the instant client and Oracle server 9.2.0.7.0, 10.2.0.3.0?? If it is a bug in Oracle (No!!! say it isn't so ... Not

Re: Oracle make test failing on HP/UX

2007-07-03 Thread John Scoles
Looks like you are pointing to the 64 bit binarys. You will have to use a 32 bit oracle client. You best bet is to use the 32 bit instantclient for HP. Set your ORACLE_HOME to the dir you install the 32 bit instant cleint and the LD_LIBRARY_PATH to LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

Re: DBD-Oracle VARRAY not supported

2007-06-19 Thread John Scoles
the struc (object) first. I will see what I will come up with this week. By the way do you have a pratical example of what you want? - Original Message - From: Charles Pareto [EMAIL PROTECTED] To: 'John Scoles' [EMAIL PROTECTED] Cc: dbi-users@perl.org Sent: Tuesday, June 19, 2007 1

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

2007-06-14 Thread John Scoles
seems this is a bug in the code when dealing with Solaris. So I would just ignore it for now here is a link to it http://www.nntp.perl.org/group/perl.dbi.dev/2006/01/msg4401.html I will see if I can patch DBD.Oracle and then forward it on. - Original Message - From: [EMAIL

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

2007-06-14 Thread John Scoles
patch for 10 clients and it you could test it would be great cheers John Scoles - Original Message - From: John Scoles [EMAIL PROTECTED] To: dbi-users@perl.org; [EMAIL PROTECTED] Sent: Thursday, June 14, 2007 6:38 AM Subject: Re: DBD::Oracle installation - make test failed - ORA-28000

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

2007-06-14 Thread John Scoles
'; } - Original Message - From: John Scoles [EMAIL PROTECTED] To: dbi-users@perl.org; [EMAIL PROTECTED] Sent: Thursday, June 14, 2007 6:38 AM Subject: Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked seems this is a bug in the code when dealing with Solaris. So

Re: DBD-Oracle VARRAY not supported

2007-06-14 Thread John Scoles
PROTECTED] To: 'John Scoles' [EMAIL PROTECTED] Cc: dbi-users@perl.org; [EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 12:18 PM Subject: RE: DBD-Oracle VARRAY not supported Sure, here is my example- I'm declaring a column as type varray like this: CREATE TYPE phone as varray(20) of varchar2(30

Re: Oracle.so

2007-06-14 Thread John Scoles
You most likly are not pointing to the correct Oracle path. You are pointing to most-likely the 64 bit so lisb file rather than the 32 bit so libs that DBD::Oracle requires. here are some links to similar problems http://www.issociate.de/board/goto/790359/Can't_load_Oarcle.so.html

Re: DBI connects to one oracle instance but cannot connect to others

2007-06-13 Thread John Scoles
try this use DBI; $odsn=DBI:Oracle:; $ouid=; $opwd=; $odbh= DBI-connect ($odsn,$ouid.@tmp1,$opwd); Though this most likely has little to do with DBI or DBD:Oracle and more how you are using your TNSNAME file - Original Message - From: [EMAIL PROTECTED] To: dbi-users@perl.org

Re: DBD::Informix test failure for lvarchar

2007-06-04 Thread John Siracusa
On 6/2/07, John Siracusa [EMAIL PROTECTED] wrote: Just to chime in, we have a similar problem at work: selecting a row with an LVARCHAR column in it causes a segfault(!) for us. This happens on two of our machines, but does not happen on a third. We have yet to narrow down the exact

Re: DBD::Informix test failure for lvarchar

2007-06-02 Thread John Siracusa
. In the meantime, I just wanted to add my basic we can't use LVARCHAR columns with DBD::Informix either report. -John

Re: DBD::Informix test failure for lvarchar

2007-06-02 Thread John Siracusa
On 6/2/07 5:42 PM, John Siracusa wrote: Just to chime in, we have a similar problem at work: selecting a row with an LVARCHAR column in it causes a segfault(!) for us. This happens on two of our machines, but does not happen on a third. We have yet to narrow down the exact differences. I'll

Re: DBD::Oracle -- NULL LOB Locator is not null

2007-05-29 Thread John Scoles
I think there was a patch for that one submitted but not released a while ago. I will test this against the the current version and see what I get. Sven Miller [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] (DBD::Oracle version 1.17) Given the following: my $sLobLocator; my

Re: Memory leak, DBI 1.55 + DBD::ODBC 1.13 + MS SQL 2000

2007-05-22 Thread John Scoles
Are you using IIS7? - Original Message - From: Fi Dot [EMAIL PROTECTED] To: dbi-users@perl.org Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, May 21, 2007 4:42 PM Subject: Memory leak, DBI 1.55 + DBD::ODBC 1.13 + MS SQL 2000 Hi All!

Re: Memory leak, DBI 1.55 + DBD::ODBC 1.13 + MS SQL 2000

2007-05-22 Thread John Scoles
Ok that elliminates one source of the problem. cheers - Original Message - From: Fi Dot [EMAIL PROTECTED] To: John Scoles [EMAIL PROTECTED] Cc: dbi-users@perl.org; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 22, 2007 7:42 AM Subject

Re: DBI - DBD with Oracle 10g on Windows XP

2007-05-10 Thread John Scoles
I just did the same yesterday for XP using the readme README.win32.txt so you should have no problems if you follow it. Tzekov, Ianko [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, You can install ActivePerl (I have made it with 5.6, but I think it will work with 5.8 too)-

Re: Clarification on DBI module

2007-05-09 Thread John Scoles
at it. cheers John Scoles - Original Message - From: ramesh thangamani [EMAIL PROTECTED] To: dbi-users@perl.org; [EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 3:09 AM Subject: Clarification on DBI module Hi, Can you please clarify my doubts regarding DBI perl module used

Re: Clarification on DBI module

2007-05-09 Thread John Scoles
buffer in the statment handle is not cleaned out because no execute took place. - Original Message - From: ramesh thangamani To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 8:10 AM Subject: Re: Clarification on DBI module Hi John, I

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testing with RH lunix Red Hat Linux 3.2.3-54 and perl 5.8 Ran Perl Makefile.PL but with this warning *** You are using a perl configured with threading enabled. *** You should be aware that using multiple threads is *** not recommended for production environments. *** Note: The optional

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Well just had another crack at it with a little more success I checked my ENV variable and I had LANG=en_US.UTF-8 set I removed this from my ENV and the Makefile.PL make and make test all worked as expected John Scoles [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Testing

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows XP Home Edition 2002 SP 2 Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You can download it from

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows Server 2003 SP 2 Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You can download it from

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows Vista Home Edition Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You can download it from

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Opps forgot to note that all my Windows testing was done with the latest version of ActivePerl Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You can download it from http://homepage.mac.com/tim.bunce/.Public/perl/DBI-1.55-RC3.tar.gz =head2 Changes in DBI 1.55 (svn

Re: proliferation of error messages

2007-05-04 Thread John Scoles
What are the messages??? - Original Message - From: Mary Anderson [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Friday, May 04, 2007 1:04 PM Subject: proliferation of error messages Hello all, My perl cgi script which runs dbi is generating error messages to the logs just

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Costello
Hi Tim, OS: OpenBSD 4.0 Perl: 5.8.8 CC: GCC 3.3.5 (single-threaded) Tests: All successful, 31 tests and 373 subtests skipped OS: Windows XP Pro/ cygwin-thread-multi-64-int Perl: 5.8.7 CC: GCC 3.4.4 Tests: All tests successful, 27 tests and 377 subtests skipped

Re: DBI AND DBD-ORACLE

2007-04-27 Thread John Scoles
Looks like windows has locked some files. You will have to either 1) record where the files are on the disks 2) reboot your box and see if you can uninstall 3) if you cant then try to delete them through explorer 4) if this fails open a dos window and delete them using good old dos erase 5) if

<    1   2   3   4   5   6   7   8   9   10   >