Scott T. Hildreth wrote:
On Thu, 2009-03-26 at 06:49 -0400, John Scoles wrote:
Scott T. Hildreth wrote:
On Mon, 2009-01-19 at 20:26 +0000, Russell, Gordon wrote:
Hi. I am hoping someone can look over this install info and tell me if it is 
all ok?

I am having some worries with a new install of fedora 10.
I also installed oracle 11.1.0.7.
I have the latest DBI and am installing DBD Oracle 1.22. Note I have used DBD 
and Oracle for many many years.
I have a 64 bit environment, UTF8 database and linux, with 32 bit compatibility 
libraries installed only to make the oracle installer tests happy.

Gordon,
    Did you ever resolve this?  We are moving to 11g now and I am having
the same issue.  I originally thought it was a 11g client => 10g db
problem, but I can reproduce it trying to compile DBD::Oracle using a
11g db.  Oracle 11.1.0.7.0 is installed on SUSE Linux Enterprise Server
10 (x86_64).
Thanks,
Scott.

In short, it works but produces some test errors. Not sure if I should just 
ignore them!
Plenty of information follows... any suggestions appreciated.

When building DBD Oracle, the tests come up with 3 fails:
Test Summary Report
-------------------
t/26exe_array       (Wstat: 512 Tests: 14 Failed: 2)
  Failed tests:  11, 14
  Non-zero exit status: 2
I have raised this many time with Oracle as I think it is a bug on the 11g side as no code has changed. They of course say it is DBD::Oracle fault. It might have to do with space, buffering or permissions unfortunately I do not have steady access to an 11 db to do more extensive testing.

John, are you specifically talking about the exe_array here?  Just for
the record all my tests pass, except the plsql test in 31lob.t

Yes that is the case I was talking about the exe_array. I wonder it there is a patch difference in your two Oracles or you have some different settings?

cheers
t/30long            (Wstat: 512 Tests: 30 Failed: 0)
  Non-zero exit status: 2
  Parse errors: Bad plan.  You planned 479 tests but ran 30.
t/31lob             (Wstat: 256 Tests: 6 Failed: 1)
  Failed test:  6
  Non-zero exit status: 1
  Parse errors: Bad plan.  You planned 9 tests but ran 6.

The actual errors are:
t/26exe_array...........
 Dubious, test returned 2 (wstat 512, 0x200)
 Failed 2/14 subtests
t/30long................panic: sv_len_utf8 cache 10240 real 81920 for 1234....
t/31lob.................DBD::Oracle::st execute failed: ORA-24813: cannot send or receive 
an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN ? := 
DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef, 
:p2=OCILobLocatorPtr=SCALAR(0x19cb018)] at t/31lob.t line 108.

Installing it anyway seems ok, but running:
my $dbh = DBI->connect_cached('dbi:Oracle:sid',username,password,{
    RaiseError            => 1,
    PrintError            => 0,
    ShowErrorStatement        => 1,
    AutoCommit            => 0,
    ora_verbose=>6

})
Produces:
        OCINlsEnvironmentVariableGet(871,0,93,0,2)=SUCCESS
        OCINlsEnvironmentVariableGet(871,0,94,0,2)=SUCCESS
        OCINlsEnvCreate(1b8c5d0,THREADED | OBJECT,3,0,0,0,0,0,0,871,871)=SUCCESS
        OCIHandleAlloc(1c06220,1b8c5d8,OCI_HTYPE_ERROR,0,0)=SUCCESS
       charset id=871, name=UTF8, ncharset id=871, name=UTF8 (csid: utf8=871 
al32utf8=873)
        OCIHandleAlloc(1c06220,1b8c5e0,OCI_HTYPE_SERVER,0,0)=SUCCESS
        OCIHandleAlloc(1c06220,1b8c5e8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
        OCIServerAttach(1c45608, 1c44e68, "sid", 3, mode=DEFAULT,0)=SUCCESS
        OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c45608,0,6,1c44e68)=SUCCESS
        OCIHandleAlloc(1c06220,1b8c5f0,OCI_HTYPE_SESSION,0,0)=SUCCESS
        OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1a1d348,8,22,1c44e68)=SUCCESS
        OCIAttrSet(1c81838,OCI_HTYPE_SESSION,1917d08,6,23,1c44e68)=SUCCESS
        OCISessionBegin(1c44d90,1c44e68,1c81838,1,mode=DEFAULT 0)=SUCCESS
        OCIAttrSet(1c44d90,OCI_HTYPE_SVCCTX,1c81838,0,7,1c44e68)=SUCCESS
"DBI::db=HASH(0x1919710)" is not exported by the DBD::Oracle module
Can't continue after import errors at ./demo.pl line 7
BEGIN failed--compilation aborted at ./demo.pl line 15.
        OCITransRollback(1c44d90,1c44e68,mode=DEFAULT 0)=SUCCESS
        OCISessionEnd(1c44d90,1c44e68,1c81838,mode=DEFAULT 0)=SUCCESS
        OCIServerDetach(1c45608,1c44e68,mode=DEFAULT,0)=SUCCESS
        OCIHandleFree(1c81838,OCI_HTYPE_SESSION)=SUCCESS
        OCIHandleFree(1c45608,OCI_HTYPE_SERVER)=SUCCESS
        OCIHandleFree(1c44d90,OCI_HTYPE_SVCCTX)=SUCCESS
        OCIHandleFree(1c44e68,OCI_HTYPE_ERROR)=SUCCESS

Looking through the makefile and running ldd on the .so file it seems to have 
only used the 64 bit oracle libraries....
Let me know if I can add anything.

Thanks
Gordon.


Napier University is the best modern university in Scotland* and number one in 
Scotland for graduate employability**
(*Guardian University Guide 2009)
(**HESA 2008)

This message is intended for the addressee(s) only and should not be read, 
copied or disclosed to anyone else outwith the University without the 
permission of the sender.
It is your responsibility to ensure that this message and any attachments are 
scanned for viruses or other defects. Napier University does not accept 
liability for any loss or damage which may result from this email or any 
attachment, or for errors or omissions arising after it was sent. Email is not 
a secure medium. Email entering the University's system is subject to routine 
monitoring and filtering by the University.
Napier University is a registered Scottish charity. Registration number SC018373


Reply via email to