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 > >> 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 > >> > >> > >>