On Thu, 2009-03-26 at 10:48 -0500, Scott T. Hildreth wrote: > On Thu, 2009-03-26 at 11:45 -0400, John Scoles wrote: > > > > 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? > > I can have the DBA send me what patches have been applied, if you like. > I am going to debug the 31lob.t test some more, I will report back my > findings.
It is definitely a 11g client issue. I can use a 10g client, connecting to a 11g db and the test works fine. Our DBA had me declare local vars inside the plsql test, just testing different things, so my statement is a little different; same problem, ok 1 - returned valid locator ok 2 - returned valid locator ok 3 - returned valid locator ok 4 - returned length ok 5 - returned written value DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "declare xlen number ; xlob blob; B xlob := ?; xlen := DBMS_LOB.GETLENGTH( xlob ); END;" with ParamValues: :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0xa5b490)] at t/31lob.t line 108. at t/31lob.t line 108 not ok 6 - returned length via PL/SQL Errors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x00100AF68], [0], [0], [0], [], [], [] Errors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x00100AF68], [0], [0], [0], [], [], [] > > > > > 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 > > >>>> > > >>>> > > >>>> > > >>>>