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

2007-06-14 Thread liuhang
Thanks, Philip. I was eventually aware of that while I was reading the README. I then set the ORACLE_USERID to a valid Oracle account, and a 'make realclean' before I start the whole installation over. Most of the tests went OK but I still got two (and only two) other tests failed: # make test

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
Opps checkeing the error msg and the code seems I have already fixed that one a while back so it might be like this one http://www.nntp.perl.org/group/perl.dbi.users/2006/11/msg30463.html Same client as you so it might be a bug in Oracle client??? Cannot test directly but I will see if I can

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

2007-06-14 Thread John Scoles
Try this patch on 10general.t and see what comes up. It should skip the test. I do not have access to a solaris box so it is going to be a hit or miss sort of thing. Cheers use DBD::Oracle qw(ORA_OCI); unshift @INC ,'t'; require 'nchar_test_lib.pl'; $| = 1; plan tests = 33; my $dsn =

Re: DBD-Oracle VARRAY not supported

2007-06-14 Thread John Scoles
Well I have had a look into it and I do not think there is anything in DBD::Oracle we have to do to make varray work as it is simple SQL and is handled at the OCI level of the SQL commnd For example the following script works without any issues. #!/usr/local/bin/perl#use DBI;use strict;use vars

Oracle.so

2007-06-14 Thread Loo, Peter # PHX
Hi, The same program that ran successfully yesterday is failing with the following error today. Can someone please shed some light what this error means? ERROR: Connection failed to x for user x. install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.7/s

RE: Oracle.so

2007-06-14 Thread Kong, Alan
Did you set SHLIB_PATH, LD_LIBRARY_PATH, and LD_RUN_PATH? -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 1:53 PM To: dbi-users@perl.org Subject: Oracle.so Hi, The same program that ran successfully yesterday is failing with the

Re: Oracle.so

2007-06-14 Thread Mike Nhan
Hi, Did you compile/installed with the 32bit libclntsh and now you are pointing it at the 64bit version of the library so you are getting a 64bit library warning? o.10.1: wrong ELF class: ELFCLASS64 at Did your library path or oracle_home changed? Michael On Thu, 14 Jun 2007, Loo, Peter

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: Oracle.so

2007-06-14 Thread Loo, Peter # PHX
Thanks John and Mike. I was trying to run it through the cron so the required environment was not being set correctly. I have fixed that and all is working again. Thanks. Peter -Original Message- From: John Scoles [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 11:09 AM To:

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

2007-06-14 Thread liuhang
Thanks for all the replies, John. I tried to use your patch of 10general.t, it did skip the first two tests so no more complaints about the wrong return values from exit. But the test 20 and 21 still failed, the errors seem to be Oracle doesn't have the Procedural option installed

Re: DBD::Informix test failure for lvarchar - bug found!

2007-06-14 Thread Mark Abajian
Dear Mr. Leffler, When I saw this Tuesday night, I thought... wow. Thanks so much for pursuing this bug report. I will feel more confident in using DBD::Informix, now that you have verified that this bug will not bite us in our present configuration (no lvarchar not null columns). I'm