Re: DBD-Oracle on AIX

John R Pierce wrote:
> I've built DBD-Oracle-1.24 along with Perl 5.12.0 and DBI-1.611 for 
> IBM AIX 6.1 TL05 (oslevel = 6100-05-01), with Oracle 10.2.0.4, using 
> IBM XL C v11.1 + the latest PTF.
>
> to build DBD-Oracle, i had to hack the makefile slightly to remove a 
> bogus -q32 from the LD commands, this per the README.aix.txt notes, 
> otherwise my build is pretty much bog stock.   Since I used cc_r to 
> compile perl (per the Perl readmes for AIX) I also used this variant 
> of the compiler for DBD-Oracle...
>
> Its failing just one test t/58object.t ...   make test output is 
> below...   I don't know how to resolve this.  The description of 
> ORA-24334 is darn cryptic.
>
ugh, the make test output came out unreadable, lets try again...

$ make test
        PERL_DL_NONLAZY=1 /opt/fis/perl5/bin/perl 
"-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 
'blib/arch')" t/*.t
t/01base.t .............. # Test loading DBI, DBD::Oracle and version
t/01base.t .............. ok  
t/10general.t ........... ok    
t/12impdata.t ........... ok  
t/14threads.t ........... ok    
t/15nls.t ............... ok  
t/20select.t ............ ok    
t/21nchar.t ............. ok    
t/22nchar_al32utf8.t .... ok   
t/22nchar_utf8.t ........ ok    
t/23wide_db.t ........... ok   
t/23wide_db_8bit.t ...... ok   
t/23wide_db_al32utf8.t .. ok    
t/24implicit_utf8.t ..... ok    
t/25plsql.t ............. ok    
t/26exe_array.t ......... ok    
t/28array_bind.t ........ ok    
t/30long.t .............. ok      
t/31lob.t ............... ok    
t/31lob_extended.t ...... ok    
t/32xmltype.t ........... ok  
t/34pres_lobs.t ......... ok    
t/40ph_type.t ........... 1/19  Placeholder behaviour for ora_type=1 
VARCHAR2 (the default) varies with Oracle version.
 Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
 Your system doesn't. If that seems odd, let us know.
t/40ph_type.t ........... ok    
t/50cursor.t ............ ok        
t/51scroll.t ............ ok    
t/55nested.t ............ ok    
t/56embbeded.t .......... ok  
t/58object.t ............ 1/51 DBD::Oracle::db prepare failed: 
ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for 
Statement "select * from dbd_test__obj_table order by id"] at 
t/58object.t line 116.
t/58object.t ............ Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 46/51 subtests
t/60reauth.t ............ skipped: ORACLE_USERID_2 not defined.
t/70meta.t .............. ok    
t/80ora_charset.t ....... ok    

Test Summary Report
-------------------
t/58object.t          (Wstat: 65280 Tests: 5 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 51 tests but ran 5.
Files=30, Tests=2227, 16 wallclock secs ( 0.58 usr  0.06 sys +  7.31 
cusr  0.99 csys =  8.94 CPU)
Result: FAIL
Failed 1/30 test programs. 0/2227 subtests failed.
make: 1254-004 The error code from the last command is 255.


Stop.