Thanks John, if you need me to run any debugging on Solaris or anything let me know. I would suspect also that it is OS related.
On the premise instant client and also tried to run perl Makefile.PL -V 9.2 & with -v 10.2.0.4 The only thing that is out of place is this compile a warning is thrown when the make command is run gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include -I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI -D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\" -DXS_VERSION=\"1.21\" -fPIC "-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\" dbdimp.c dbdimp.c: In function `ora_st_execute_array': dbdimp.c:3269: warning: unused variable `sv2' Full output of the make, ux11:/home/bmpe/bmpadme/DBD-Oracle-1.21 > make Skip blib/lib/DBD/Oracle.pm (unchanged) Skip blib/lib/DBD/mkta.pl (unchanged) Skip blib/lib/oraperl.ph (unchanged) Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged) Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged) Skip blib/lib/Oraperl.pm (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged) gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include -I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI -D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\" -DXS_VERSION=\"1.21\" -fPIC "-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\" DBD_ORA_OBJ.c gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include -I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI -D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\" -DXS_VERSION=\"1.21\" -fPIC "-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\" Oracle.c *gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include -I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI -D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\" -DXS_VERSION=\"1.21\" -fPIC "-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\" dbdimp.c dbdimp.c: In function `ora_st_execute_array': dbdimp.c:3269: warning: unused variable `sv2'* gcc -c -I/home/bmpe/bmpadme/instantclient_10_2/sdk/include -I/opt/perl586/lib/site_perl/5.8.6/sun4-solaris-thread-multi/auto/DBI -D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\" -DXS_VERSION=\"1.21\" -fPIC "-I/opt/perl586/lib/5.8.6/sun4-solaris-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.4\" oci8.c Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/home/bmpe/bmpadme/instantclient_10_2" gcc -G -L/usr/local/lib DBD_ORA_OBJ.o Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so -L/home/bmpe/bmpadme/instantclient_10_2 -lclntsh chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs cp ora_explain blib/script/ora_explain /usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain Manifying blib/man1/ora_explain.1 Manifying blib/man3/DBD::Oracle.3 Manifying blib/man3/DBD::Oraperl.3 On Sun, Apr 5, 2009 at 8:05 AM, <sco...@pythian.com> wrote: > I tested it and I got the correct values back > Looking at the error you are now getting in 10gen that is an OS related > error This is the basic check that we can fork subprocesses and wait for > the status after having connected to Oracle > > It is only suppose to run on solaris if the oci is gt 9. > > In your case this is true but your DB is 9.2 which leads me to thing it > is the combination of 9.2 db and solaris that is the root cause. > > You might not have a work around for this. I am able to get this to work > on windos and linux without any problem > > I will look a little further though. > > Cheers > John Scoles > > > > Have been trying to get a good install all day for DBD 1.21 / DBD1.22 on > > Solaris 5.8, it installs now. > > However it still fails on the TEST_ORA table. > > > > As I said I tried it on my Windows box using Activestate/ppm which > queried > > the TEST_ORA table successfully > > > > The latest Solaris build I used was as follows > > > > instantclient-*10.2.0.4.0* 32bit* - this seems to be the version of > > instant > > client that works* > > perl, v5.8.6 built for sun4-solaris-thread-multi > > SunOS 5.8 > > Oracle 9.2.0.8.0 > > DBD 1.21 > > > > After running a sucessful perl Makefile.PL, make, then make test I read > > the > > following post by John > > > > http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg32950.html > > > > I then ran the make install and re-tried my sample test but still the > > issue > > occurs, otherwsise standard SQL works fine. > > > > DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this > position > > (DBD ERROR: OCIParamGet) [for Statement "select * from TEST_ORA"] at > > ./popAMAError.pl line 34. > > > > The output from Make test > > > > > > PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" > > "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t > > t/01base................ok > > > > t/10general.............# Failed test (t/10general.t at line 36) > > t/10general.............NOK 1# got: '-1' > > > > # expected: '256' > > # Failed test (t/10general.t at line 37) > > # got: '-1' > > # expected: '0' > > t/10general.............ok 33/33# Looks like you failed 2 tests of 33. > > > > t/10general.............dubious > > > > Test returned status 2 (wstat 512, 0x200) > > DIED. FAILED tests 1-2 > > Failed 2/33 tests, 93.94% okay > > t/12impdata.............ok > > > > t/14threads.............ok > > > > t/15nls.................ok > > > > t/20select..............ok > > > > t/21nchar............... Database and client versions and character sets: > > Database 9.2.0.8.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is > > AL16UTF16 (Unicode) > > Client 10.2.0.4 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>' > > t/21nchar...............ok > > > > t/22nchar_al32utf8......ok > > > > t/22nchar_utf8..........ok > > > > t/23wide_db.............skipped > > all skipped: Database character set is not Unicode > > t/23wide_db_8bit........skipped > > all skipped: Database character set is not Unicode > > t/23wide_db_al32utf8....skipped > > all skipped: Database character set is not Unicode > > t/24implicit_utf8.......ok > > > > t/25plsql...............ok 42/82(DBI::errstr undefined) > > > > t/25plsql...............FAILED test 43 > > > > Failed 1/82 tests, 98.78% okay > > t/26exe_array...........ok > > > > t/28array_bind..........ok > > > > t/30long................ok > > > > 122/470 skipped: various reasons > > t/31lob.................ok > > > > t/32xmltype.............ok > > > > t/34pres_lobs...........ok > > > > t/40ph_type.............ok 3/19 Placeholder behaviour for ora_type=1 (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.............ok > > > > t/50cursor..............ok > > > > t/51scroll..............ok > > > > t/55nested..............ok > > > > t/56embbeded............ok > > > > t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped. > > skipped > > all skipped: no reason given > > t/70meta................ok > > > > t/80ora_charset.........ok 8/14# Failed test (t/80ora_charset.t at > > line > > 83) > > # got: '?' > > # expected: '°' > > t/80ora_charset.........NOK 9# Failed test (t/80ora_charset.t at line > > 84) > > # got: '?' > > # expected: '°' > > t/80ora_charset.........ok 12/14# Failed test (t/80ora_charset.t at > > line > > 83) > > # got: '?' > > # expected: '°' > > t/80ora_charset.........NOK 13# Failed test (t/80ora_charset.t at > line > > 84) > > t/80ora_charset.........NOK 14# got: '?' > > > > # expected: '°' > > # Looks like you failed 4 tests of 14. > > t/80ora_charset.........dubious > > > > Test returned status 4 (wstat 1024, 0x400) > > DIED. FAILED tests 9-10, 13-14 > > Failed 4/14 tests, 71.43% okay > > Failed Test Stat Wstat Total Fail Failed List of Failed > > > ------------------------------------------------------------------------------- > > t/10general.t 2 512 33 2 6.06% 1-2 > > t/25plsql.t 82 1 1.22% 43 > > t/80ora_charset.t 4 1024 14 4 28.57% 9-10 13-14 > > 4 tests and 122 subtests skipped. > > Failed 3/28 test scripts, 89.29% okay. 7/2033 subtests failed, 99.66% > > okay. > > make: *** [test_dynamic] Error 2 > > > > > > On Fri, Apr 3, 2009 at 11:46 AM, Jamie Nicholson > > <jamie.nichol...@gmail.com>wrote: > > > >> Tried this using Oracle 1.21 on my Windoze PC and it works. > >> Looks like I'm off to upgrade the Oracle Client as per option 2 in this > >> archive > >> > >> http://www.nntp.perl.org/group/perl.dbi.users/2008/04/msg32777.html > >> > > > >
