DBD-Oracle on AIX

[email protected] (John R Pierce)
Newsgroups perl.dbi.users
Message-ID <[email protected]>
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.



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


and, my perl looks like...

$ perl -V
Summary of my perl5 (revision 5 version 12 subversion 0) configuration:
  
  Platform:
    osname=aix, osvers=6.1.0.0, archname=aix-thread-multi
    uname='aix my-power520 1 6 00c5e4454c00 '
    config_args='-d -Dcc=cc_r -Duseshrplib -Dusethreads 
-Dprefix=/opt/fis/perl5'
    hint=recommended, useposix=true, d_sigaction=define
    useithreads=define, usemultiplicity=define
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
    use64bitint=undef, use64bitall=undef, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc_r -q32', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE 
-D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN 
-DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong',
    optimize='-O',
    cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT'
    ccversion='11.1.0.1', gccversion='', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', 
lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='ld', ldflags =' -brtl -bdynamic -b32 -bmaxdata:0x80000000'
    libpth=/lib /usr/lib /usr/ccs/lib
    libs=-lbind -lnsl -ldbm -ldb -ldl -lld -lm -lcrypt -lpthreads -lc
    perllibs=-lbind -lnsl -ldl -lld -lm -lcrypt -lpthreads -lc
    libc=/lib/libc.a, so=a, useshrplib=true, libperl=libperl.a
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='  
-bE:/opt/fis/perl5/lib/5.12.0/aix-thread-multi/CORE/perl.exp'
    cccdlflags=' ', lddlflags='-bhalt:4 -G -bI:$(PERL_INC)/perl.exp 
-bE:$(BASEEXT).exp -bnoentry -lpthreads -lc -lm'


Characteristics of this binary (from libperl):
  Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
                        PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_ITHREADS
                        USE_LARGE_FILES USE_PERLIO USE_PERL_ATOF
                        USE_REENTRANT_API
  Built under aix
  Compiled at May 12 2010 18:06:22
  @INC:
    /opt/fis/perl5/lib/site_perl/5.12.0/aix-thread-multi
    /opt/fis/perl5/lib/site_perl/5.12.0
    /opt/fis/perl5/lib/5.12.0/aix-thread-multi
    /opt/fis/perl5/lib/5.12.0
    .
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.