PATH=C:\Perl-5.22-64\site\bin;C:\Perl-5.22-64\bin;C:\MinGW-64\bin;C:\cygwin\bin;C:\instantclient_11_2-64;C:\Perl-5.22-64\site\bin;C:\Perl-5.22-64\bin;C:\MinGW-64\bin;C:\cygwin\bin;C:\instantclient_11_2-64;C:\Perl-5.22-64\site\bin;C:\Perl-5.22-64\bin;C:\MinGW-64\bin;C:\cygwin\bin;C:\instantclient_11_2-64;C:\p4;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Git\cmd;C:\Program Files (x86)\CMake\bin Start 2016-01-14T06:00:14 ActivePerl-2201 CPAN-2.00 PATH=C:/CPANFL~4.22-/var/libs/bin;C:\PERL-5~2.22-\site\bin;C:\PERL-5~2.22-\bin;C:\MinGW-64\bin;C:\cygwin\bin;C:\INSTAN~1;C:\PERL-5~2.22-\site\bin;C:\PERL-5~2.22-\bin;C:\MinGW-64\bin;C:\cygwin\bin;C:\INSTAN~1;C:\PERL-5~2.22-\site\bin;C:\PERL-5~2.22-\bin;C:\MinGW-64\bin;C:\cygwin\bin;C:\INSTAN~1;C:\p4;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WINDOW~1\v1.0\;C:\PROGRA~1\Git\cmd;C:\PROGRA~2\CMake\bin Reading 'C:\cpanfly-5.22-64\var\cpan\Metadata' Database was generated on Thu, 14 Jan 2016 05:29:02 GMT Running make for P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz Checksum for C:\cpanfly-5.22-64\var\cpan\sources\authors\id\P\PY\PYTHIAN\DBD-Oracle-1.74.tar.gz ok DBD-Oracle-1.74/ DBD-Oracle-1.74/lib/ DBD-Oracle-1.74/lib/DBD/ DBD-Oracle-1.74/lib/DBD/Oracle.pm DBD-Oracle-1.74/lib/DBD/Oracle/ DBD-Oracle-1.74/lib/DBD/Oracle/GetInfo.pm DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/ DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Win32.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Vms.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Hpux.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Aix.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Sun.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Macos.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Linux.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Cygwin.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting/Win64.pod DBD-Oracle-1.74/lib/DBD/Oracle/Troubleshooting.pod DBD-Oracle-1.74/lib/DBD/Oracle/Object.pm DBD-Oracle-1.74/oci.def DBD-Oracle-1.74/Makefile.PL DBD-Oracle-1.74/MANIFEST DBD-Oracle-1.74/ocitrace.h DBD-Oracle-1.74/Changes DBD-Oracle-1.74/LICENSE DBD-Oracle-1.74/README.help.txt DBD-Oracle-1.74/README.mkdn DBD-Oracle-1.74/CONTRIBUTING.mkd DBD-Oracle-1.74/INSTALL DBD-Oracle-1.74/Oracle.xs DBD-Oracle-1.74/CONTRIBUTORS DBD-Oracle-1.74/META.json DBD-Oracle-1.74/oci8.c DBD-Oracle-1.74/META.yml DBD-Oracle-1.74/Oracle.h DBD-Oracle-1.74/dbivport.h DBD-Oracle-1.74/typemap DBD-Oracle-1.74/t/ DBD-Oracle-1.74/t/23wide_db_al32utf8.t DBD-Oracle-1.74/t/00versions.t DBD-Oracle-1.74/t/22nchar_al32utf8.t DBD-Oracle-1.74/t/31lob.t DBD-Oracle-1.74/t/lib/ DBD-Oracle-1.74/t/lib/ExecuteArray.pm DBD-Oracle-1.74/t/10general.t DBD-Oracle-1.74/t/28array_bind.t DBD-Oracle-1.74/t/26exe_array.t DBD-Oracle-1.74/t/14threads.t DBD-Oracle-1.74/t/rt74753-utf8-encoded.t DBD-Oracle-1.74/t/23wide_db.t DBD-Oracle-1.74/t/22nchar_utf8.t DBD-Oracle-1.74/t/31lob_extended.t DBD-Oracle-1.74/t/000-report-versions-tiny.t DBD-Oracle-1.74/t/12impdata.t DBD-Oracle-1.74/t/36lob_leak.t DBD-Oracle-1.74/t/24implicit_utf8.t DBD-Oracle-1.74/t/38taf.t DBD-Oracle-1.74/t/21nchar.t DBD-Oracle-1.74/t/70meta.t DBD-Oracle-1.74/t/15nls.t DBD-Oracle-1.74/t/39attr.t DBD-Oracle-1.74/t/rt85886.t DBD-Oracle-1.74/t/34pres_lobs.t DBD-Oracle-1.74/t/56embbeded.t DBD-Oracle-1.74/t/40ph_type.t DBD-Oracle-1.74/t/55nested.t DBD-Oracle-1.74/t/30long.t DBD-Oracle-1.74/t/32xmltype.t DBD-Oracle-1.74/t/58object.t DBD-Oracle-1.74/t/50cursor.t DBD-Oracle-1.74/t/80ora_charset.t DBD-Oracle-1.74/t/51scroll.t DBD-Oracle-1.74/t/01base.t DBD-Oracle-1.74/t/20select.t DBD-Oracle-1.74/t/nchar_test_lib.pl DBD-Oracle-1.74/t/23wide_db_8bit.t DBD-Oracle-1.74/t/60reauth.t DBD-Oracle-1.74/t/rt13865.t DBD-Oracle-1.74/t/25plsql.t DBD-Oracle-1.74/examples/ DBD-Oracle-1.74/examples/japh DBD-Oracle-1.74/examples/oradump.pl DBD-Oracle-1.74/examples/ora_explain.pl DBD-Oracle-1.74/examples/commit.pl DBD-Oracle-1.74/examples/bind.pl DBD-Oracle-1.74/examples/curref.pl DBD-Oracle-1.74/examples/ex.pl DBD-Oracle-1.74/examples/read_long_via_blob_read.pl DBD-Oracle-1.74/examples/tabinfo.pl DBD-Oracle-1.74/examples/proc.pl DBD-Oracle-1.74/examples/sql DBD-Oracle-1.74/examples/mktable.pl DBD-Oracle-1.74/examples/inserting_longs.pl DBD-Oracle-1.74/examples/README DBD-Oracle-1.74/mkta.pl DBD-Oracle-1.74/Todo DBD-Oracle-1.74/dbdimp.h DBD-Oracle-1.74/hints/ DBD-Oracle-1.74/hints/macos_syms.pl DBD-Oracle-1.74/hints/macos_bundle.syms DBD-Oracle-1.74/hints/macos_lib.syms DBD-Oracle-1.74/hints/dgux.pl DBD-Oracle-1.74/hints/svr4.pl DBD-Oracle-1.74/dbdimp.c DBD-Oracle-1.74/README CPAN.pm: Building P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz >>> C:\Perl-5.22-64\bin\perl.exe Makefile.PL Multiple copies of Driver.xst found in: C:/cpanfly-5.22-64/var/megalib/auto/DBI/ C:/Perl-5.22-64/lib/auto/DBI/ at Makefile.PL line 39. Using DBI 1.634 (for perl 5.022001 on MSWin32-x64-multi-thread) installed in C:/cpanfly-5.22-64/var/megalib/auto/DBI/ Configuring DBD::Oracle for perl 5.022001 on MSWin32 (MSWin32-x64-multi-thread) Remember to actually *READ* the README file! Especially if you have any problems. Installing on a MSWin32, Ver#6.1 Using Oracle in C:/instantclient_11_2-64 DEFINE _SQLPLUS_RELEASE = "1102000100" (CHAR) Oracle version 11.2.0.1 (11.2) Using OCI directory 'sdk' client_version=11.2 DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112 Checking for functioning wait.ph System: perl5.022001 Compiler: gcc -s -O2 -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields Linker: not found Sysliblist: Checking if your kit is complete... Looks good Have \cpanfl~4.22-\var\megalib Want \perl-5~2.22-\lib Your perl and your Config.pm seem to have different ideas about the architecture they are running on. Perl thinks: [megalib] Config says: [MSWin32-x64-multi-thread] This may or may not cause problems. Please check your installation of perl if you have problems building this extension. LD_RUN_PATH=C:/instantclient_11_2-64/lib:C:/instantclient_11_2-64/rdbms/lib Using DBD::Oracle 1.74. Using DBD::Oracle 1.74. Multiple copies of Driver.xst found in: C:/cpanfly-5.22-64/var/megalib/auto/DBI/ C:/Perl-5.22-64/lib/auto/DBI/ at Makefile.PL line 1789. Using DBI 1.634 (for perl 5.022001 on MSWin32-x64-multi-thread) installed in C:/cpanfly-5.22-64/var/megalib/auto/DBI/ Generating a dmake-style Makefile Writing Makefile for DBD::Oracle Writing MYMETA.yml and MYMETA.json *** If you have problems... read all the log printed above, and the README and README.help.txt files. (Of course, you have read README by now anyway, haven't you?) >>> dmake cp lib/DBD/Oracle/Object.pm blib\lib\DBD\Oracle\Object.pm cp lib/DBD/Oracle/Troubleshooting/Macos.pod blib\lib\DBD\Oracle\Troubleshooting\Macos.pod cp dbdimp.h blib\arch\auto\DBD\Oracle/dbdimp.h cp mk.pm blib\arch\auto\DBD\Oracle/mk.pm cp lib/DBD/Oracle/Troubleshooting/Linux.pod blib\lib\DBD\Oracle\Troubleshooting\Linux.pod cp lib/DBD/Oracle/Troubleshooting/Vms.pod blib\lib\DBD\Oracle\Troubleshooting\Vms.pod cp lib/DBD/Oracle/Troubleshooting/Cygwin.pod blib\lib\DBD\Oracle\Troubleshooting\Cygwin.pod cp ocitrace.h blib\arch\auto\DBD\Oracle/ocitrace.h cp lib/DBD/Oracle/Troubleshooting/Win32.pod blib\lib\DBD\Oracle\Troubleshooting\Win32.pod cp lib/DBD/Oracle/Troubleshooting/Hpux.pod blib\lib\DBD\Oracle\Troubleshooting\Hpux.pod cp lib/DBD/Oracle/Troubleshooting/Win64.pod blib\lib\DBD\Oracle\Troubleshooting\Win64.pod cp Oracle.h blib\arch\auto\DBD\Oracle/Oracle.h cp lib/DBD/Oracle/GetInfo.pm blib\lib\DBD\Oracle\GetInfo.pm cp lib/DBD/Oracle/Troubleshooting/Sun.pod blib\lib\DBD\Oracle\Troubleshooting\Sun.pod cp lib/DBD/Oracle.pm blib\lib\DBD\Oracle.pm cp lib/DBD/Oracle/Troubleshooting/Aix.pod blib\lib\DBD\Oracle\Troubleshooting\Aix.pod cp lib/DBD/Oracle/Troubleshooting.pod blib\lib\DBD\Oracle\Troubleshooting.pod Running Mkbootstrap for DBD::Oracle () "C:\Perl-5.22-64\bin\perl.exe" -MExtUtils::Command -e chmod -- 644 "Oracle.bs" "C:\Perl-5.22-64\bin\perl.exe" -p -e "s/~DRIVER~/Oracle/g" C:\cpanfly-5.22-64\var\megalib\auto\DBI\Driver.xst > Oracle.xsi "C:\Perl-5.22-64\bin\perl.exe" "C:\cpanfly-5.22-64\var\megalib\ExtUtils\xsubpp" -typemap "C:\Perl-5.22-64\lib\ExtUtils\typemap" -typemap "typemap" Oracle.xs > Oracle.xsc && "C:\Perl-5.22-64\bin\perl.exe" -MExtUtils::Command -e mv -- Oracle.xsc Oracle.c gcc -c -IC:/instantclient_11_2-64/sdk/include -IC:/instantclient_11_2-64/rdbms/demo -IC:\cpanfly-5.22-64\var\megalib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -s -O2 -DVERSION=\"1.74\" -DXS_VERSION=\"1.74\" "-IC:\Perl-5.22-64\lib\CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112 Oracle.c gcc -c -IC:/instantclient_11_2-64/sdk/include -IC:/instantclient_11_2-64/rdbms/demo -IC:\cpanfly-5.22-64\var\megalib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -s -O2 -DVERSION=\"1.74\" -DXS_VERSION=\"1.74\" "-IC:\Perl-5.22-64\lib\CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112 dbdimp.c dbdimp.c: In function 'GetRegKey': dbdimp.c:130:2: warning: pointer targets in passing argument 5 of 'RegQueryValueExA' differ in signedness [-Wpointer-sign] c:\mingw-64\bin\../lib/gcc/x86_64-w64-mingw32/4.6.3/../../../../x86_64-w64-mingw32/include/winreg.h:183:25: note: expected 'LPBYTE' but argument is of type 'char *' dbdimp.c: In function 'dbd_fbh_dump': dbdimp.c:223:2: warning: unused variable 'my_perl' [-Wunused-variable] dbdimp.c: In function 'ora_db_login6': dbdimp.c:725:5: warning: format '%d' expects argument of type 'int', but argument 12 has type 'size_t' [-Wformat] dbdimp.c:725:5: warning: format '%d' expects argument of type 'int', but argument 14 has type 'size_t' [-Wformat] dbdimp.c: In function 'ora_db_commit': dbdimp.c:881:2: warning: unused variable 'my_perl' [-Wunused-variable] dbdimp.c: In function 'ora_st_cancel': dbdimp.c:895:2: warning: unused variable 'my_perl' [-Wunused-variable] dbdimp.c: In function 'ora_db_rollback': dbdimp.c:916:2: warning: unused variable 'my_perl' [-Wunused-variable] dbdimp.c: In function 'dbd_rebind_ph_char': dbdimp.c:2560:35: warning: format '%ld' expects argument of type 'long int', but argument 3 has type 'IV' [-Wformat] dbdimp.c:2560:35: warning: format '%ld' expects argument of type 'long int', but argument 4 has type 'STRLEN' [-Wformat] dbdimp.c:2574:35: warning: format '%ld' expects argument of type 'long int', but argument 3 has type 'IV' [-Wformat] dbdimp.c:2574:35: warning: format '%ld' expects argument of type 'long int', but argument 4 has type 'STRLEN' [-Wformat] dbdimp.c:2607:27: warning: format '%ld' expects argument of type 'long int', but argument 3 has type 'STRLEN' [-Wformat] dbdimp.c: In function 'pp_exec_rset': dbdimp.c:2817:49: warning: cast from pointer to integer of different size [-Wpointer-to-int-cast] dbdimp.c: In function 'ora_bind_ph': dbdimp.c:3150:4: warning: cast from pointer to integer of different size [-Wpointer-to-int-cast] dbdimp.c: In function 'ora_st_rows': dbdimp.c:4063:2: warning: unused variable 'my_perl' [-Wunused-variable] dbdimp.c: In function 'ora_free_templob': dbdimp.c:4188:2: warning: unused variable 'my_perl' [-Wunused-variable] dbdimp.c: In function 'ora_st_FETCH_attrib': dbdimp.c:4349:9: warning: unused variable 'imp_dbh' [-Wunused-variable] dbdimp.c: In function 'dump_env_to_trace': dbdimp.c:4519:2: warning: unused variable 'my_perl' [-Wunused-variable] gcc -c -IC:/instantclient_11_2-64/sdk/include -IC:/instantclient_11_2-64/rdbms/demo -IC:\cpanfly-5.22-64\var\megalib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -s -O2 -DVERSION=\"1.74\" -DXS_VERSION=\"1.74\" "-IC:\Perl-5.22-64\lib\CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112 oci8.c oci8.c: In function 'oci_db_handle': oci8.c:940:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'oci_st_handle': oci8.c:958:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'ora_utf8_to_bytes': oci8.c:1390:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'dbd_rebind_ph_rset': oci8.c:1576:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'ora_blob_read_mb_piece': oci8.c:1847:4: warning: format '%lu' expects argument of type 'long unsigned int', but argument 6 has type 'ub4' [-Wformat] oci8.c: In function 'fetch_func_autolob': oci8.c:2180:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'calc_cache_rows': oci8.c:2218:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'rs_array_init': oci8.c:2962:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'describe_obj': oci8.c:3120:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'dump_struct': oci8.c:3355:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'ora_db_reauthenticate': oci8.c:4291:2: warning: unused variable 'my_perl' [-Wunused-variable] oci8.c: In function 'ora_db_version': oci8.c:4922:2: warning: unused variable 'my_perl' [-Wunused-variable] "C:\Perl-5.22-64\bin\perl.exe" -MExtUtils::Mksymlists \ -e "Mksymlists('NAME'=>\"DBD::Oracle\", 'DLBASE' => 'Oracle', 'DL_FUNCS' => { }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);" dlltool --def Oracle.def --output-exp dll.exp g++ -o blib\arch\auto\DBD\Oracle\Oracle.dll -mdll -s -static-libgcc -static-libstdc++ -L"C:\Perl-5.22-64\lib\CORE" -L"C:\MinGW\x86_64-w64-mingw32\lib" Oracle.o dbdimp.o oci8.o "C:\Perl-5.22-64\lib\CORE\libperl522.a" "liboci.a" "C:\MinGW\x86_64-w64-mingw32\lib\libmoldname.a" "C:\MinGW\x86_64-w64-mingw32\lib\libkernel32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libuser32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libgdi32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libwinspool.a" "C:\MinGW\x86_64-w64-mingw32\lib\libcomdlg32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libadvapi32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libshell32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libole32.a" "C:\MinGW\x86_64-w64-mingw32\lib\liboleaut32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libnetapi32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libuuid.a" "C:\MinGW\x86_64-w64-mingw32\lib\libws2_32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libmpr.a" "C:\MinGW\x86_64-w64-mingw32\lib\libwinmm.a" "C:\MinGW\x86_64-w64-mingw32\lib\libversion.a" "C:\MinGW\x86_64-w64-mingw32\lib\libodbc32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libodbccp32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libcomctl32.a" dll.exp dlltool --def Oracle.def --output-exp dll.exp g++ -o blib\arch\auto\DBD\Oracle\Oracle.dll -mdll -s -static-libgcc -static-libstdc++ -L"C:\Perl-5.22-64\lib\CORE" -L"C:\MinGW\x86_64-w64-mingw32\lib" Oracle.o dbdimp.o oci8.o "C:\Perl-5.22-64\lib\CORE\libperl522.a" "liboci.a" "C:\MinGW\x86_64-w64-mingw32\lib\libmoldname.a" "C:\MinGW\x86_64-w64-mingw32\lib\libkernel32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libuser32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libgdi32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libwinspool.a" "C:\MinGW\x86_64-w64-mingw32\lib\libcomdlg32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libadvapi32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libshell32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libole32.a" "C:\MinGW\x86_64-w64-mingw32\lib\liboleaut32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libnetapi32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libuuid.a" "C:\MinGW\x86_64-w64-mingw32\lib\libws2_32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libmpr.a" "C:\MinGW\x86_64-w64-mingw32\lib\libwinmm.a" "C:\MinGW\x86_64-w64-mingw32\lib\libversion.a" "C:\MinGW\x86_64-w64-mingw32\lib\libodbc32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libodbccp32.a" "C:\MinGW\x86_64-w64-mingw32\lib\libcomctl32.a" dll.exp "C:\Perl-5.22-64\bin\perl.exe" -MExtUtils::Command -e chmod -- 755 blib\arch\auto\DBD\Oracle\Oracle.dll PYTHIAN/DBD-Oracle-1.74.tar.gz dmake -- OK Running make test >>> dmake test TEST_VERBOSE=1 "C:\Perl-5.22-64\bin\perl.exe" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(1, 'blib\lib', 'blib\arch')" t/*.t # # # Generated by Dist::Zilla::Plugin::ReportVersions::Tiny v1.10 # perl: 5.022001 (wanted 5.006) on MSWin32 from C:\Perl-5.22-64\bin\perl.exe # # B => 1.58 (want any version) # Carp => 1.38 (want any version) # DBI => 1.634 (want 1.51) # Data::Dumper => 2.154 (want any version) # Devel::Peek => 1.22 (want any version) # DynaLoader => 1.32 (want any version) # Encode => 2.78 (want any version) # Exporter => 5.72 (want any version) # ExtUtils::MakeMaker => 7.0401 (want 6.30) # Math::BigInt => 1.999715 (want any version) # Test::More => 1.001014 (want 0.88) # Thread::Semaphore => 2.12 (want any version) # lib => 0.63 (want any version) # strict => 1.09 (want any version) # utf8 => 1.17 (want any version) # vars => 1.03 (want any version) # warnings => 1.34 (want any version) # # Thanks for using my code. I hope it works for you. # If not, please try and include this output in the bug report. # That will help me reproduce the issue and solve your problem. # t/000-report-versions-tiny.t .. ok 1 - we really didn't test anything, just reporting data 1..1 ok # OCI client library version: 11.2.0.1 # database version: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production t/00versions.t ................ 1..2 ok 1 ok 2 ok t/01base.t .................... 1..6 ok 1 - require DBI; ok 2 - successfully import DBI ok 3 - internal ok 4 - install_driver ok 5 - install_driver ok 6 - version ok t/10general.t ................. 1..28 ok 1 # skip not unix-like ok 2 # skip not unix-like ok 3 - preparse, case insensitive, placeholders in comments ok 4 - number of parameters ok 5 - expected number of parameters ok 6 - bind_param for select parameter ok 7 - execute for select parameter ok 8 - NUM_OF_FIELDS ok 9 - unrecognised attribute ok 10 - statement is active ok 11 - finish ok 12 - statement is not active ok 13 - execute for user_tables ok 14 - active for user_tables ok 15 - user_tables not active after fetch ok 16 - set NLS_NUMERIC_CHARACTERS ok 17 - select all for arithmetic ok 18 - tmp0=.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001 ok 19 - tmp1=999999999990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 ok 20 - eval error: ``DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "some invalid sql statement"] at t/10general.t line 110. # '' expected 'do failed:' ok 21 - warn error: ``DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "some invalid sql statement"] at t/10general.t line 110. # '' expected 'do failed:' ok 22 - err defined ok 23 - ping - connected # ORA_OCI = 11 (11.2.0.1) ok 24 - ora_oci defined ok 25 - ora_oci 11.2.0.1 >= 8 ok 26 - version has 2 or more components ok 27 - version looks like numbers ok 28 - first number is int ok t/12impdata.t ................. 1..7 ok 1 - 1 kid ok 2 - 1 active kid ok 3 - no kids ok 4 - no active kids ok 5 - got same session ok 6 - 1 kid ok 7 - 1 active kid ok t/14threads.t ................. 1..19 ok 1 - session 0 created ok 2 - session 1 matches previous session ok 3 - session 2 matches previous session ok 4 - session 3 matches previous session ok 5 - session 4 matches previous session ok 6 - one imp_data in pool ok 7 - thread gets two separate sessions ok 8 - get same session after free ok 9 - two imp_data in pool ok 10 - thread 0, loop 1 created session ok 11 - thread 1, loop 1 matches previous session ok 12 - thread 2, loop 1 matches previous session ok 13 - thread 0, loop 2 matches previous session ok 14 - thread 1, loop 2 matches previous session ok 15 - thread 2, loop 2 matches previous session ok 16 - thread 0, loop 3 matches previous session ok 17 - thread 1, loop 3 matches previous session ok 18 - thread 2, loop 3 matches previous session ok 19 - pool empty ok t/15nls.t ..................... 1..9 ok 1 - set date format ok 2 - ora_can_unicode ok 3 - fetch ora_nls_parameters ok 4 - check ora_nls_parameters returned hashref ok 5 - check returned nls_date_format ok 6 - alter date format ok 7 - check ora_nls_parameters caches old values ok 8 - check ora_nls_parameters returns a copy ok 9 - refetch and check new nls_date_format value ok t/20select.t .................. 1..36 ok 1 - prepare for insert of CHAR(10) ok 2 - insert 8bit or utf8 ok 3 - bind overloaded value ok 4 - insert data2 ok 5 - insert string too long ok 6 - prepare select ordered by idx ok 7 - execute ok 8 - fetchall ok 9 - first row matches ok 10 - second row matches ok 11 - third row matches ok 12 - prepare for insert of VARCHAR(10) ok 13 - insert 8bit or utf8 ok 14 - bind overloaded value ok 15 - insert data2 ok 16 - insert string too long ok 17 - prepare select ordered by idx ok 18 - execute ok 19 - fetchall ok 20 - first row matches ok 21 - second row matches ok 22 - third row matches ok 23 - prepare for insert of VARCHAR2(10) ok 24 - insert 8bit or utf8 ok 25 - bind overloaded value ok 26 - insert data2 ok 27 - insert string too long ok 28 - prepare select ordered by idx ok 29 - execute ok 30 - fetchall ok 31 - first row matches ok 32 - second row matches ok 33 - third row matches ok 34 - ds_interval ok 35 - primary key on table ok 36 - DT,IDX ok t/21nchar.t ................... # testing control and 8 bit chars: # Database and client versions and character sets: # Database 11.2.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is AL16UTF16 (Unicode) # Client 11.2.0.1 NLS_LANG is '', NLS_NCHAR is '' # set $ENV{NLS_NCHAR}=WE8ISO8859P1 1..53 # row: 1: nice_string=a byte_string=97 (a, 'a') # row: 2: nice_string=b byte_string=98 (b, 'b') # row: 3: nice_string=\x03 byte_string=3 (, '.') # row: 4: nice_string=¡ byte_string=161 (¡, '¡') # row: 5: nice_string=¢ byte_string=162 (¢, '¢') # row: 6: nice_string=£ byte_string=163 (£, '£') # create table dbd_ora__drop_mecpanfly52264 ( idx integer, nch nvarchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, nch, descr, dt ) values( ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param nch with attribute { ora_csform => 2 } ok 4 - bind_param descr withOUT attribute ora_csform ok 5 - insert row 1: lowercase a ok 6 - bind_param idx ok 7 - bind_param nch with attribute { ora_csform => 2 } ok 8 - bind_param descr withOUT attribute ora_csform ok 9 - insert row 2: lowercase b ok 10 - bind_param idx ok 11 - bind_param nch with attribute { ora_csform => 2 } ok 12 - bind_param descr withOUT attribute ora_csform ok 13 - insert row 3: control-C ok 14 - bind_param idx ok 15 - bind_param nch with attribute { ora_csform => 2 } ok 16 - bind_param descr withOUT attribute ora_csform ok 17 - insert row 4: upside down bang ok 18 - bind_param idx ok 19 - bind_param nch with attribute { ora_csform => 2 } ok 20 - bind_param descr withOUT attribute ora_csform ok 21 - insert row 5: cent char ok 22 - bind_param idx ok 23 - bind_param nch with attribute { ora_csform => 2 } ok 24 - bind_param descr withOUT attribute ora_csform ok 25 - insert row 6: british pound ok 26 - prepared: select nch, descr, DUMP(nch), dt from dbd_ora__drop_mecpanfly52264 order by idx ok 27 - bind column nch ok 28 - bind column descr ok 29 - byte_string test of row 1: column: nch lowercase a ok 30 - nice_string test of row 1: column: nch lowercase a ok 31 - byte_string test of row 1: column: descr lowercase a ok 32 - nice_string test of row 1: column: descr lowercase a ok 33 - byte_string test of row 2: column: nch lowercase b ok 34 - nice_string test of row 2: column: nch lowercase b ok 35 - byte_string test of row 2: column: descr lowercase b ok 36 - nice_string test of row 2: column: descr lowercase b ok 37 - byte_string test of row 3: column: nch control-C ok 38 - nice_string test of row 3: column: nch control-C ok 39 - byte_string test of row 3: column: descr control-C ok 40 - nice_string test of row 3: column: descr control-C ok 41 - byte_string test of row 4: column: nch upside down bang ok 42 - nice_string test of row 4: column: nch upside down bang ok 43 - byte_string test of row 4: column: descr upside down bang ok 44 - nice_string test of row 4: column: descr upside down bang ok 45 - byte_string test of row 5: column: nch cent char ok 46 - nice_string test of row 5: column: nch cent char ok 47 - byte_string test of row 5: column: descr cent char ok 48 - nice_string test of row 5: column: descr cent char ok 49 - byte_string test of row 6: column: nch british pound ok 50 - nice_string test of row 6: column: nch british pound ok 51 - byte_string test of row 6: column: descr british pound ok 52 - nice_string test of row 6: column: descr british pound ok 53 - number of rows fetched ok t/22nchar_al32utf8.t .......... # set $ENV{NLS_NCHAR}=AL32UTF8 testing utf8 with nchar columns # Database 11.2.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is AL16UTF16 (Unicode) # Client 11.2.0.1 NLS_LANG is '', NLS_NCHAR is 'AL32UTF8' 1..37 # row: 1: nice_string=\x03 byte_string=3 (, '.') # row: 2: nice_string=a byte_string=97 (a, 'a') # row: 3: nice_string=b byte_string=98 (b, 'b') # row: 4: nice_string=\x{263A} byte_string=9786 (☺, "☺") # create table dbd_ora__drop_mecpanfly52264 ( idx integer, nch nvarchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, nch, descr, dt ) values( ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param nch with attribute { ora_csform => 2 } ok 4 - bind_param descr withOUT attribute ora_csform ok 5 - insert row 1: control-C ok 6 - bind_param idx ok 7 - bind_param nch with attribute { ora_csform => 2 } ok 8 - bind_param descr withOUT attribute ora_csform ok 9 - insert row 2: lowercase a ok 10 - bind_param idx ok 11 - bind_param nch with attribute { ora_csform => 2 } ok 12 - bind_param descr withOUT attribute ora_csform ok 13 - insert row 3: lowercase b ok 14 - bind_param idx ok 15 - bind_param nch with attribute { ora_csform => 2 } ok 16 - bind_param descr withOUT attribute ora_csform ok 17 - insert row 4: smiley face ok 18 - prepared: select nch, descr, DUMP(nch), dt from dbd_ora__drop_mecpanfly52264 order by idx ok 19 - bind column nch ok 20 - bind column descr ok 21 - byte_string test of row 1: column: nch (uft8) control-C ok 22 - nice_string test of row 1: column: nch (uft8) control-C ok 23 - byte_string test of row 1: column: descr control-C ok 24 - nice_string test of row 1: column: descr control-C ok 25 - byte_string test of row 2: column: nch (uft8) lowercase a ok 26 - nice_string test of row 2: column: nch (uft8) lowercase a ok 27 - byte_string test of row 2: column: descr lowercase a ok 28 - nice_string test of row 2: column: descr lowercase a ok 29 - byte_string test of row 3: column: nch (uft8) lowercase b ok 30 - nice_string test of row 3: column: nch (uft8) lowercase b ok 31 - byte_string test of row 3: column: descr lowercase b ok 32 - nice_string test of row 3: column: descr lowercase b ok 33 - byte_string test of row 4: column: nch (uft8) smiley face ok 34 - nice_string test of row 4: column: nch (uft8) smiley face ok 35 - byte_string test of row 4: column: descr smiley face ok 36 - nice_string test of row 4: column: descr smiley face ok 37 - number of rows fetched ok t/22nchar_utf8.t .............. # set $ENV{NLS_NCHAR}=AL32UTF8 # Database 11.2.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is AL16UTF16 (Unicode) # Client 11.2.0.1 NLS_LANG is '', NLS_NCHAR is 'AL32UTF8' 1..53 # row: 1: nice_string=\x03 byte_string=3 (, '.') # row: 2: nice_string=a byte_string=97 (a, 'a') # row: 3: nice_string=b byte_string=98 (b, 'b') # row: 4: nice_string=\x{263A} byte_string=9786 (☺, "☺") # row: 5: nice_string=\x{10304} byte_string=66308 (𐌄, "𐌄") # row: 6: nice_string=\x{20301} byte_string=131841 (𠌁, "𠌁") # create table dbd_ora__drop_mecpanfly52264 ( idx integer, nch nvarchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, nch, descr, dt ) values( ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param nch with attribute { ora_csform => 2 } ok 4 - bind_param descr withOUT attribute ora_csform ok 5 - insert row 1: control-C ok 6 - bind_param idx ok 7 - bind_param nch with attribute { ora_csform => 2 } ok 8 - bind_param descr withOUT attribute ora_csform ok 9 - insert row 2: lowercase a ok 10 - bind_param idx ok 11 - bind_param nch with attribute { ora_csform => 2 } ok 12 - bind_param descr withOUT attribute ora_csform ok 13 - insert row 3: lowercase b ok 14 - bind_param idx ok 15 - bind_param nch with attribute { ora_csform => 2 } ok 16 - bind_param descr withOUT attribute ora_csform ok 17 - insert row 4: smiley face ok 18 - bind_param idx ok 19 - bind_param nch with attribute { ora_csform => 2 } ok 20 - bind_param descr withOUT attribute ora_csform ok 21 - insert row 5: SMP Plane 1 wide char ok 22 - bind_param idx ok 23 - bind_param nch with attribute { ora_csform => 2 } ok 24 - bind_param descr withOUT attribute ora_csform ok 25 - insert row 6: SIP Plane 2 wide char ok 26 - prepared: select nch, descr, DUMP(nch), dt from dbd_ora__drop_mecpanfly52264 order by idx ok 27 - bind column nch ok 28 - bind column descr ok 29 - byte_string test of row 1: column: nch (uft8) control-C ok 30 - nice_string test of row 1: column: nch (uft8) control-C ok 31 - byte_string test of row 1: column: descr control-C ok 32 - nice_string test of row 1: column: descr control-C ok 33 - byte_string test of row 2: column: nch (uft8) lowercase a ok 34 - nice_string test of row 2: column: nch (uft8) lowercase a ok 35 - byte_string test of row 2: column: descr lowercase a ok 36 - nice_string test of row 2: column: descr lowercase a ok 37 - byte_string test of row 3: column: nch (uft8) lowercase b ok 38 - nice_string test of row 3: column: nch (uft8) lowercase b ok 39 - byte_string test of row 3: column: descr lowercase b ok 40 - nice_string test of row 3: column: descr lowercase b ok 41 - byte_string test of row 4: column: nch (uft8) smiley face ok 42 - nice_string test of row 4: column: nch (uft8) smiley face ok 43 - byte_string test of row 4: column: descr smiley face ok 44 - nice_string test of row 4: column: descr smiley face ok 45 - byte_string test of row 5: column: nch (uft8) SMP Plane 1 wide char ok 46 - nice_string test of row 5: column: nch (uft8) SMP Plane 1 wide char ok 47 - byte_string test of row 5: column: descr SMP Plane 1 wide char ok 48 - nice_string test of row 5: column: descr SMP Plane 1 wide char ok 49 - byte_string test of row 6: column: nch (uft8) SIP Plane 2 wide char ok 50 - nice_string test of row 6: column: nch (uft8) SIP Plane 2 wide char ok 51 - byte_string test of row 6: column: descr SIP Plane 2 wide char ok 52 - nice_string test of row 6: column: descr SIP Plane 2 wide char ok 53 - number of rows fetched ok t/23wide_db.t ................. # set $ENV{NLS_LANG='AMERICAN_AMERICA.AL32UTF8' 1..37 # row: 1: nice_string=\x03 byte_string=3 (, '.') # row: 2: nice_string=a byte_string=97 (a, 'a') # row: 3: nice_string=b byte_string=98 (b, 'b') # row: 4: nice_string=\x{263A} byte_string=9786 (☺, "☺") # create table dbd_ora__drop_mecpanfly52264 ( idx integer, ch varchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, ch, descr, dt ) values( ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param ch withOUT attribute ora_csform ok 4 - bind_param descr withOUT attribute ora_csform ok 5 - insert row 1: control-C ok 6 - bind_param idx ok 7 - bind_param ch withOUT attribute ora_csform ok 8 - bind_param descr withOUT attribute ora_csform ok 9 - insert row 2: lowercase a ok 10 - bind_param idx ok 11 - bind_param ch withOUT attribute ora_csform ok 12 - bind_param descr withOUT attribute ora_csform ok 13 - insert row 3: lowercase b ok 14 - bind_param idx ok 15 - bind_param ch withOUT attribute ora_csform ok 16 - bind_param descr withOUT attribute ora_csform ok 17 - insert row 4: smiley face ok 18 - prepared: select ch, descr, DUMP(ch), dt from dbd_ora__drop_mecpanfly52264 order by idx ok 19 - bind column ch ok 20 - bind column descr ok 21 - byte_string test of row 1: column: ch (uft8) control-C ok 22 - nice_string test of row 1: column: ch (uft8) control-C ok 23 - byte_string test of row 1: column: descr (uft8) control-C ok 24 - nice_string test of row 1: column: descr (uft8) control-C ok 25 - byte_string test of row 2: column: ch (uft8) lowercase a ok 26 - nice_string test of row 2: column: ch (uft8) lowercase a ok 27 - byte_string test of row 2: column: descr (uft8) lowercase a ok 28 - nice_string test of row 2: column: descr (uft8) lowercase a ok 29 - byte_string test of row 3: column: ch (uft8) lowercase b ok 30 - nice_string test of row 3: column: ch (uft8) lowercase b ok 31 - byte_string test of row 3: column: descr (uft8) lowercase b ok 32 - nice_string test of row 3: column: descr (uft8) lowercase b ok 33 - byte_string test of row 4: column: ch (uft8) smiley face ok 34 - nice_string test of row 4: column: ch (uft8) smiley face ok 35 - byte_string test of row 4: column: descr (uft8) smiley face ok 36 - nice_string test of row 4: column: descr (uft8) smiley face ok 37 - number of rows fetched ok t/23wide_db_8bit.t ............ # set $ENV{NLS_LANG='AMERICAN_AMERICA.WE8MSWIN1252' testing utf8 with char columns (wide mode database) 1..53 # row: 1: nice_string=a byte_string=97 (a, 'a') # row: 2: nice_string=b byte_string=98 (b, 'b') # row: 3: nice_string=\x03 byte_string=3 (, '.') # row: 4: nice_string=¡ byte_string=161 (¡, '¡') # row: 5: nice_string=¢ byte_string=162 (¢, '¢') # row: 6: nice_string=£ byte_string=163 (£, '£') # create table dbd_ora__drop_mecpanfly52264 ( idx integer, ch varchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, ch, descr, dt ) values( ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param ch withOUT attribute ora_csform ok 4 - bind_param descr withOUT attribute ora_csform ok 5 - insert row 1: lowercase a ok 6 - bind_param idx ok 7 - bind_param ch withOUT attribute ora_csform ok 8 - bind_param descr withOUT attribute ora_csform ok 9 - insert row 2: lowercase b ok 10 - bind_param idx ok 11 - bind_param ch withOUT attribute ora_csform ok 12 - bind_param descr withOUT attribute ora_csform ok 13 - insert row 3: control-C ok 14 - bind_param idx ok 15 - bind_param ch withOUT attribute ora_csform ok 16 - bind_param descr withOUT attribute ora_csform ok 17 - insert row 4: upside down bang ok 18 - bind_param idx ok 19 - bind_param ch withOUT attribute ora_csform ok 20 - bind_param descr withOUT attribute ora_csform ok 21 - insert row 5: cent char ok 22 - bind_param idx ok 23 - bind_param ch withOUT attribute ora_csform ok 24 - bind_param descr withOUT attribute ora_csform ok 25 - insert row 6: british pound ok 26 - prepared: select ch, descr, DUMP(ch), dt from dbd_ora__drop_mecpanfly52264 order by idx ok 27 - bind column ch ok 28 - bind column descr ok 29 - byte_string test of row 1: column: ch lowercase a ok 30 - nice_string test of row 1: column: ch lowercase a ok 31 - byte_string test of row 1: column: descr lowercase a ok 32 - nice_string test of row 1: column: descr lowercase a ok 33 - byte_string test of row 2: column: ch lowercase b ok 34 - nice_string test of row 2: column: ch lowercase b ok 35 - byte_string test of row 2: column: descr lowercase b ok 36 - nice_string test of row 2: column: descr lowercase b ok 37 - byte_string test of row 3: column: ch control-C ok 38 - nice_string test of row 3: column: ch control-C ok 39 - byte_string test of row 3: column: descr control-C ok 40 - nice_string test of row 3: column: descr control-C ok 41 - byte_string test of row 4: column: ch upside down bang ok 42 - nice_string test of row 4: column: ch upside down bang ok 43 - byte_string test of row 4: column: descr upside down bang ok 44 - nice_string test of row 4: column: descr upside down bang ok 45 - byte_string test of row 5: column: ch cent char ok 46 - nice_string test of row 5: column: ch cent char ok 47 - byte_string test of row 5: column: descr cent char ok 48 - nice_string test of row 5: column: descr cent char ok 49 - byte_string test of row 6: column: ch british pound ok 50 - nice_string test of row 6: column: ch british pound ok 51 - byte_string test of row 6: column: descr british pound ok 52 - nice_string test of row 6: column: descr british pound ok 53 - number of rows fetched ok t/23wide_db_al32utf8.t ........ # set $ENV{NLS_LANG='AMERICAN_AMERICA.AL32UTF8' 1..37 # row: 1: nice_string=\x03 byte_string=3 (, '.') # row: 2: nice_string=a byte_string=97 (a, 'a') # row: 3: nice_string=b byte_string=98 (b, 'b') # row: 4: nice_string=\x{263A} byte_string=9786 (☺, "☺") # create table dbd_ora__drop_mecpanfly52264 ( idx integer, ch varchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, ch, descr, dt ) values( ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param ch withOUT attribute ora_csform ok 4 - bind_param descr withOUT attribute ora_csform ok 5 - insert row 1: control-C ok 6 - bind_param idx ok 7 - bind_param ch withOUT attribute ora_csform ok 8 - bind_param descr withOUT attribute ora_csform ok 9 - insert row 2: lowercase a ok 10 - bind_param idx ok 11 - bind_param ch withOUT attribute ora_csform ok 12 - bind_param descr withOUT attribute ora_csform ok 13 - insert row 3: lowercase b ok 14 - bind_param idx ok 15 - bind_param ch withOUT attribute ora_csform ok 16 - bind_param descr withOUT attribute ora_csform ok 17 - insert row 4: smiley face ok 18 - prepared: select ch, descr, DUMP(ch), dt from dbd_ora__drop_mecpanfly52264 order by idx ok 19 - bind column ch ok 20 - bind column descr ok 21 - byte_string test of row 1: column: ch (uft8) control-C ok 22 - nice_string test of row 1: column: ch (uft8) control-C ok 23 - byte_string test of row 1: column: descr (uft8) control-C ok 24 - nice_string test of row 1: column: descr (uft8) control-C ok 25 - byte_string test of row 2: column: ch (uft8) lowercase a ok 26 - nice_string test of row 2: column: ch (uft8) lowercase a ok 27 - byte_string test of row 2: column: descr (uft8) lowercase a ok 28 - nice_string test of row 2: column: descr (uft8) lowercase a ok 29 - byte_string test of row 3: column: ch (uft8) lowercase b ok 30 - nice_string test of row 3: column: ch (uft8) lowercase b ok 31 - byte_string test of row 3: column: descr (uft8) lowercase b ok 32 - nice_string test of row 3: column: descr (uft8) lowercase b ok 33 - byte_string test of row 4: column: ch (uft8) smiley face ok 34 - nice_string test of row 4: column: ch (uft8) smiley face ok 35 - byte_string test of row 4: column: descr (uft8) smiley face ok 36 - nice_string test of row 4: column: descr (uft8) smiley face ok 37 - number of rows fetched ok t/24implicit_utf8.t ........... 1..74 # row: 1: nice_string=\x03 byte_string=3 (, '.') # row: 2: nice_string=a byte_string=97 (a, 'a') # row: 3: nice_string=b byte_string=98 (b, 'b') # row: 4: nice_string=\x{263A} byte_string=9786 (☺, "☺") # set $ENV{NLS_NCHAR}=UTF8 # Database 11.2.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is AL16UTF16 (Unicode) # Client 11.2.0.1 NLS_LANG is '', NLS_NCHAR is 'UTF8' # create table dbd_ora__drop_mecpanfly52264 ( idx integer, nch nvarchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, nch, descr, dt ) values( ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param nch ok 4 - bind_param descr withOUT attribute ora_csform ok 5 - insert row 1: control-C ok 6 - bind_param idx ok 7 - bind_param nch ok 8 - bind_param descr withOUT attribute ora_csform ok 9 - insert row 2: lowercase a ok 10 - bind_param idx ok 11 - bind_param nch ok 12 - bind_param descr withOUT attribute ora_csform ok 13 - insert row 3: lowercase b ok 14 - bind_param idx ok 15 - bind_param nch ok 16 - bind_param descr withOUT attribute ora_csform ok 17 - insert row 4: smiley face ok 18 - prepared: select nch, descr, DUMP(nch), dt from dbd_ora__drop_mecpanfly52264 order by idx ok 19 - bind column nch ok 20 - bind column descr ok 21 - byte_string test of row 1: column: nch (uft8) control-C ok 22 - nice_string test of row 1: column: nch (uft8) control-C ok 23 - byte_string test of row 1: column: descr control-C ok 24 - nice_string test of row 1: column: descr control-C ok 25 - byte_string test of row 2: column: nch (uft8) lowercase a ok 26 - nice_string test of row 2: column: nch (uft8) lowercase a ok 27 - byte_string test of row 2: column: descr lowercase a ok 28 - nice_string test of row 2: column: descr lowercase a ok 29 - byte_string test of row 3: column: nch (uft8) lowercase b ok 30 - nice_string test of row 3: column: nch (uft8) lowercase b ok 31 - byte_string test of row 3: column: descr lowercase b ok 32 - nice_string test of row 3: column: descr lowercase b ok 33 - byte_string test of row 4: column: nch (uft8) smiley face ok 34 - nice_string test of row 4: column: nch (uft8) smiley face ok 35 - byte_string test of row 4: column: descr smiley face ok 36 - nice_string test of row 4: column: descr smiley face ok 37 - number of rows fetched # set $ENV{NLS_NCHAR}=AL32UTF8 # Database 11.2.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is AL16UTF16 (Unicode) # Client 11.2.0.1 NLS_LANG is '', NLS_NCHAR is 'AL32UTF8' # create table dbd_ora__drop_mecpanfly52264 ( idx integer, nch nvarchar2(20), descr varchar2(50), dt date ) ok 38 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, nch, descr, dt ) values( ?, ?, ?, sysdate ) ok 39 - bind_param idx ok 40 - bind_param nch ok 41 - bind_param descr withOUT attribute ora_csform ok 42 - insert row 1: control-C ok 43 - bind_param idx ok 44 - bind_param nch ok 45 - bind_param descr withOUT attribute ora_csform ok 46 - insert row 2: lowercase a ok 47 - bind_param idx ok 48 - bind_param nch ok 49 - bind_param descr withOUT attribute ora_csform ok 50 - insert row 3: lowercase b ok 51 - bind_param idx ok 52 - bind_param nch ok 53 - bind_param descr withOUT attribute ora_csform ok 54 - insert row 4: smiley face ok 55 - prepared: select nch, descr, DUMP(nch), dt from dbd_ora__drop_mecpanfly52264 order by idx ok 56 - bind column nch ok 57 - bind column descr ok 58 - byte_string test of row 1: column: nch (uft8) control-C ok 59 - nice_string test of row 1: column: nch (uft8) control-C ok 60 - byte_string test of row 1: column: descr control-C ok 61 - nice_string test of row 1: column: descr control-C ok 62 - byte_string test of row 2: column: nch (uft8) lowercase a ok 63 - nice_string test of row 2: column: nch (uft8) lowercase a ok 64 - byte_string test of row 2: column: descr lowercase a ok 65 - nice_string test of row 2: column: descr lowercase a ok 66 - byte_string test of row 3: column: nch (uft8) lowercase b ok 67 - nice_string test of row 3: column: nch (uft8) lowercase b ok 68 - byte_string test of row 3: column: descr lowercase b ok 69 - nice_string test of row 3: column: descr lowercase b ok 70 - byte_string test of row 4: column: nch (uft8) smiley face ok 71 - nice_string test of row 4: column: nch (uft8) smiley face ok 72 - byte_string test of row 4: column: descr smiley face ok 73 - nice_string test of row 4: column: descr smiley face ok 74 - number of rows fetched ok t/25plsql.t ................... 1..82 ok 1 - prepare raising predefined exception ok 2 - execute predefined exception ok 3 - err expected 1722 error ok 4 - err does not get cleared ok 5 - prepare user defined expcetion ok 6 - execute user defined exception ok 7 - user exception 6510 error ok 8 - prepare raise application error with literal values ok 9 - execite raise application error with literal values ok 10 - expected 20101 error ok 11 - app error ok 12 - prepare raise application error with in params ok 13 - execute raise application error with in params ok 14 - expected 20042 error ok 15 - hello world msg ok 16 - prepare named numeric in/out params ok 17 - bind arg ok 18 - bind mult ok 19 - execute named numeric in/out params ok 20 - expected 3 * 3 = 6 ok 21 - execute named numeric in/out params 10 times ok 22 - expected p1 = 1024 ok 23 - prepare undef parameters ok 24 - bind arg ok 25 - execute undef parameters ok 26 - prepare named string in/out parameters ok 27 - bind arg ok 28 - bind append ok 29 - execute named string in/out parameters ok 30 - expected HELLO WORLD ok 31 - execute named string in/out parameters 1- times ok 32 - p1 as expected ok 33 - execute binding a null ok 34 - get a null string back ok 35 - prepare nvl ok 36 - bind out ok 37 - bind in ok 38 - execute nvl ok 39 - expected FOO ok 40 - bind empty string ok 41 - execute empty string ok 42 - returned null string ok 43 - prepare test output buffer too small ok 44 - bind arg ok 45 - output buffer too small ok 46 - rebind arg with more space ok 47 - execute rebind with more space ok 48 - expected return length ok 49 - dbms_output_enable ok 50 - dbms_output_put ok 51 - dbms_output_get foo ok 52 - dbms_output_get bar ok 53 - dbms_output_get baz:boo ok 54 - prepare cursor ok 55 - bind p1 ok 56 - bind cursor ok 57 - execute for cursor ok 58 - rows: 1348 ok 59 - ref = sql ok 60 - bind p1 ok 61 - execute for cursor ok 62 - expected ref to new handle ok 63 - ref = sql # Before p1=[Hello] p2=[Y] p3=[Y] ok 64 - test bind_param_inout for non assigned ok 65 - p1 ok ok 66 - p2 ok ok 67 - p3 ok # After p1=[Hello] p2=[Y] p3=[Y] ok 68 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 69 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 70 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 71 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 72 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 73 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 74 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 75 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 76 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 77 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 78 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 79 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 80 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 81 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok 82 # skip Can't create a function (ORA-01031: insufficient privileges (DBD ERROR: OCIStmtExecute)) ok t/26exe_array.t ............... # ***** error handler called ***** # Table dropped ok 1 - create test table # simple tests raise = 1, array_context = 1 # all param arrays the same size # Autocommit: 1 # insert tuple = ARRAY(0x2c4d738), raise = 1, commit = '', sts = 5, error = 0, array_context = 1, affected = 5 ok 2 - no error in execute_array eval ok 3 - execute_array returned 5 rows executed ok 4 - total affected 5 ok 5 - no error captured ok 6 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 7 - tuple status is an array ok 8 - status arrays same size ok 9 - row 0 tuple status unknown ok 10 - row 1 tuple status unknown ok 11 - row 2 tuple status unknown ok 12 - row 3 tuple status unknown ok 13 - row 4 tuple status unknown ok 14 - row 0 p1 data ok 15 - row 0 p2 data ok 16 - row 1 p1 data ok 17 - row 1 p2 data ok 18 - row 2 p1 data ok 19 - row 2 p2 data ok 20 - row 3 p1 data ok 21 - row 3 p2 data ok 22 - row 4 p1 data ok 23 - row 4 p2 data # Autocommit: 0 # insert raise = 1, tuple = ARRAY(0x2c4be20), commit = 1, sts = 5, error = 0, array_context = 1, affected = 5 ok 24 - no error in execute_array eval ok 25 - execute_array returned 5 rows executed ok 26 - total affected 5 ok 27 - no error captured ok 28 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 29 - tuple status is an array ok 30 - status arrays same size ok 31 - row 0 tuple status unknown ok 32 - row 1 tuple status unknown ok 33 - row 2 tuple status unknown ok 34 - row 3 tuple status unknown ok 35 - row 4 tuple status unknown ok 36 - row 0 p1 data ok 37 - row 0 p2 data ok 38 - row 1 p1 data ok 39 - row 1 p2 data ok 40 - row 2 p1 data ok 41 - row 2 p2 data ok 42 - row 3 p1 data ok 43 - row 3 p2 data ok 44 - row 4 p1 data ok 45 - row 4 p2 data # Not all param arrays the same size # insert array_context = 1, affected = 5, error = 0, raise = 1, tuple = ARRAY(0x2c4be20), commit = 0, sts = 5 ok 46 - no error in execute_array eval ok 47 - execute_array returned 5 rows executed ok 48 - total affected 5 ok 49 - no error captured ok 50 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 51 - tuple status is an array ok 52 - status arrays same size ok 53 - row 0 tuple status unknown ok 54 - row 1 tuple status unknown ok 55 - row 2 tuple status unknown ok 56 - row 3 tuple status unknown ok 57 - row 4 tuple status unknown ok 58 - row 0 p1 data ok 59 - row 0 p2 data ok 60 - row 1 p1 data ok 61 - row 1 p2 data ok 62 - row 2 p1 data ok 63 - row 2 p2 data ok 64 - row 3 p1 data ok 65 - row 3 p2 data ok 66 - row 4 p1 data ok 67 - row 4 p2 data # Not all param arrays the same size with bind on execute_array # insert affected = 5, sts = 5, raise = 1, params = ARRAY(0x2c4d528), array_context = 1, error = 0, commit = 0, tuple = ARRAY(0x2c4f548) ok 68 - no error in execute_array eval ok 69 - execute_array returned 5 rows executed ok 70 - total affected 5 ok 71 - no error captured ok 72 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 73 - tuple status is an array ok 74 - status arrays same size ok 75 - row 0 tuple status unknown ok 76 - row 1 tuple status unknown ok 77 - row 2 tuple status unknown ok 78 - row 3 tuple status unknown ok 79 - row 4 tuple status unknown ok 80 - row 0 p1 data ok 81 - row 0 p2 data ok 82 - row 1 p1 data ok 83 - row 1 p2 data ok 84 - row 2 p1 data ok 85 - row 2 p2 data ok 86 - row 3 p1 data ok 87 - row 3 p2 data ok 88 - row 4 p1 data ok 89 - row 4 p2 data # no parameters # insert commit = 0, tuple = ARRAY(0x2c4d3f0), array_context = 1, error = 0, sts = '0E0', raise = 1, params = ARRAY(0x2c50738), affected = 0 ok 90 - no error in execute_array eval ok 91 - execute_array returned '0E0' rows executed ok 92 - total affected 0 ok 93 - no error captured ok 94 - 0E0 rows in tuple_status # $ArrayTupleStatus = []; ok 95 - tuple status is an array ok 96 - status arrays same size # simple tests array_context = 0, raise = 1 # all param arrays the same size # Autocommit: 1 # insert tuple = ARRAY(0x2ddb860), raise = 1, commit = '', sts = 5, error = 0, array_context = 0, affected = 5 ok 97 - no error in execute_array eval ok 98 - execute_array returned 5 rows executed ok 99 - no error captured ok 100 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 101 - tuple status is an array ok 102 - status arrays same size ok 103 - row 0 tuple status unknown ok 104 - row 1 tuple status unknown ok 105 - row 2 tuple status unknown ok 106 - row 3 tuple status unknown ok 107 - row 4 tuple status unknown ok 108 - row 0 p1 data ok 109 - row 0 p2 data ok 110 - row 1 p1 data ok 111 - row 1 p2 data ok 112 - row 2 p1 data ok 113 - row 2 p2 data ok 114 - row 3 p1 data ok 115 - row 3 p2 data ok 116 - row 4 p1 data ok 117 - row 4 p2 data # Autocommit: 0 # insert array_context = 0, error = 0, affected = 5, commit = 1, sts = 5, raise = 1, tuple = ARRAY(0x2c4faa0) ok 118 - no error in execute_array eval ok 119 - execute_array returned 5 rows executed ok 120 - no error captured ok 121 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 122 - tuple status is an array ok 123 - status arrays same size ok 124 - row 0 tuple status unknown ok 125 - row 1 tuple status unknown ok 126 - row 2 tuple status unknown ok 127 - row 3 tuple status unknown ok 128 - row 4 tuple status unknown ok 129 - row 0 p1 data ok 130 - row 0 p2 data ok 131 - row 1 p1 data ok 132 - row 1 p2 data ok 133 - row 2 p1 data ok 134 - row 2 p2 data ok 135 - row 3 p1 data ok 136 - row 3 p2 data ok 137 - row 4 p1 data ok 138 - row 4 p2 data # Not all param arrays the same size # insert raise = 1, tuple = ARRAY(0x2c4faa0), sts = 5, commit = 0, array_context = 0, error = 0, affected = 5 ok 139 - no error in execute_array eval ok 140 - execute_array returned 5 rows executed ok 141 - no error captured ok 142 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 143 - tuple status is an array ok 144 - status arrays same size ok 145 - row 0 tuple status unknown ok 146 - row 1 tuple status unknown ok 147 - row 2 tuple status unknown ok 148 - row 3 tuple status unknown ok 149 - row 4 tuple status unknown ok 150 - row 0 p1 data ok 151 - row 0 p2 data ok 152 - row 1 p1 data ok 153 - row 1 p2 data ok 154 - row 2 p1 data ok 155 - row 2 p2 data ok 156 - row 3 p1 data ok 157 - row 3 p2 data ok 158 - row 4 p1 data ok 159 - row 4 p2 data # Not all param arrays the same size with bind on execute_array # insert sts = 5, params = ARRAY(0x2c4f650), raise = 1, affected = 5, commit = 0, tuple = ARRAY(0x2ddfc68), array_context = 0, error = 0 ok 160 - no error in execute_array eval ok 161 - execute_array returned 5 rows executed ok 162 - no error captured ok 163 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 164 - tuple status is an array ok 165 - status arrays same size ok 166 - row 0 tuple status unknown ok 167 - row 1 tuple status unknown ok 168 - row 2 tuple status unknown ok 169 - row 3 tuple status unknown ok 170 - row 4 tuple status unknown ok 171 - row 0 p1 data ok 172 - row 0 p2 data ok 173 - row 1 p1 data ok 174 - row 1 p2 data ok 175 - row 2 p1 data ok 176 - row 2 p2 data ok 177 - row 3 p1 data ok 178 - row 3 p2 data ok 179 - row 4 p1 data ok 180 - row 4 p2 data # no parameters # insert error = 0, array_context = 0, commit = 0, tuple = ARRAY(0x2ddec70), affected = 0, sts = '0E0', raise = 1, params = ARRAY(0x2ddfcb0) ok 181 - no error in execute_array eval ok 182 - execute_array returned '0E0' rows executed ok 183 - no error captured ok 184 - 0E0 rows in tuple_status # $ArrayTupleStatus = []; ok 185 - tuple status is an array ok 186 - status arrays same size # error tests raise = 1, array_context = 1 # Last row in error # insert error = 1, array_context = 1, affected = undef, raise = 1, tuple = ARRAY(0x2de4a48), commit = 0, sts = undef # ***** error handler called ***** ok 187 - error in execute_array eval ok 188 - error captured # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # [ # 1, # 'ORA-00001: unique constraint (TEST.SYS_C0019584) violated (DBD SUCCESS_WITH_INFO)', # 'S1000' # ] # ]; ok 189 - tuple status is an array ok 190 - status arrays same size ok 191 - row 0 tuple status unknown ok 192 - row 1 tuple status unknown ok 193 - row 2 tuple status unknown ok 194 - row 3 tuple status unknown ok 195 - row 0 p1 data ok 196 - row 0 p2 data ok 197 - row 1 p1 data ok 198 - row 1 p2 data ok 199 - row 2 p1 data ok 200 - row 2 p2 data ok 201 - row 3 p1 data ok 202 - row 3 p2 data # 2nd last row in error # insert tuple = ARRAY(0x2de6cf0), raise = 1, sts = undef, commit = 0, array_context = 1, error = 1, affected = undef # ***** error handler called ***** ok 203 - error in execute_array eval ok 204 - error captured # $ArrayTupleStatus = [ # -1, # -1, # -1, # [ # 1, # 'ORA-00001: unique constraint (TEST.SYS_C0019584) violated (DBD SUCCESS_WITH_INFO)', # 'S1000' # ], # -1 # ]; ok 205 - tuple status is an array ok 206 - status arrays same size ok 207 - row 0 tuple status unknown ok 208 - row 1 tuple status unknown ok 209 - row 2 tuple status unknown ok 210 - row 4 tuple status unknown ok 211 - row 0 p1 data ok 212 - row 0 p2 data ok 213 - row 1 p1 data ok 214 - row 1 p2 data ok 215 - row 2 p1 data ok 216 - row 2 p2 data ok 217 - row 3 p1 data ok 218 - row 3 p2 data # error tests array_context = 0, raise = 1 # Last row in error # insert sts = undef, commit = 0, tuple = ARRAY(0x2de54e0), raise = 1, error = 1, array_context = 0, affected = undef # ***** error handler called ***** ok 219 - error in execute_array eval ok 220 - error captured # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # [ # 1, # 'ORA-00001: unique constraint (TEST.SYS_C0019584) violated (DBD SUCCESS_WITH_INFO)', # 'S1000' # ] # ]; ok 221 - tuple status is an array ok 222 - status arrays same size ok 223 - row 0 tuple status unknown ok 224 - row 1 tuple status unknown ok 225 - row 2 tuple status unknown ok 226 - row 3 tuple status unknown ok 227 - row 0 p1 data ok 228 - row 0 p2 data ok 229 - row 1 p1 data ok 230 - row 1 p2 data ok 231 - row 2 p1 data ok 232 - row 2 p2 data ok 233 - row 3 p1 data ok 234 - row 3 p2 data # 2nd last row in error # insert tuple = ARRAY(0x2de8120), raise = 1, commit = 0, sts = undef, array_context = 0, error = 1, affected = undef # ***** error handler called ***** ok 235 - error in execute_array eval ok 236 - error captured # $ArrayTupleStatus = [ # -1, # -1, # -1, # [ # 1, # 'ORA-00001: unique constraint (TEST.SYS_C0019584) violated (DBD SUCCESS_WITH_INFO)', # 'S1000' # ], # -1 # ]; ok 237 - tuple status is an array ok 238 - status arrays same size ok 239 - row 0 tuple status unknown ok 240 - row 1 tuple status unknown ok 241 - row 2 tuple status unknown ok 242 - row 4 tuple status unknown ok 243 - row 0 p1 data ok 244 - row 0 p2 data ok 245 - row 1 p1 data ok 246 - row 1 p2 data ok 247 - row 2 p1 data ok 248 - row 2 p2 data ok 249 - row 3 p1 data ok 250 - row 3 p2 data # error tests raise = 0, array_context = 1 # Last row in error # insert error = 1, array_context = 1, affected = undef, tuple = ARRAY(0x2de9af8), raise = 0, sts = undef, commit = 0 # ***** error handler called ***** ok 251 - no error in execute_array eval ok 252 - execute_array returned undef rows executed ok 253 - total affected undef # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # [ # 1, # 'ORA-00001: unique constraint (TEST.SYS_C0019584) violated (DBD SUCCESS_WITH_INFO)', # 'S1000' # ] # ]; ok 254 - tuple status is an array ok 255 - status arrays same size ok 256 - row 0 tuple status unknown ok 257 - row 1 tuple status unknown ok 258 - row 2 tuple status unknown ok 259 - row 3 tuple status unknown ok 260 - row 0 p1 data ok 261 - row 0 p2 data ok 262 - row 1 p1 data ok 263 - row 1 p2 data ok 264 - row 2 p1 data ok 265 - row 2 p2 data ok 266 - row 3 p1 data ok 267 - row 3 p2 data # 2nd last row in error # insert array_context = 1, affected = undef, error = 1, sts = undef, commit = 0, tuple = ARRAY(0x2dea758), raise = 0 # ***** error handler called ***** ok 268 - no error in execute_array eval ok 269 - execute_array returned undef rows executed ok 270 - total affected undef # $ArrayTupleStatus = [ # -1, # -1, # -1, # [ # 1, # 'ORA-00001: unique constraint (TEST.SYS_C0019584) violated (DBD SUCCESS_WITH_INFO)', # 'S1000' # ], # -1 # ]; ok 271 - tuple status is an array ok 272 - status arrays same size ok 273 - row 0 tuple status unknown ok 274 - row 1 tuple status unknown ok 275 - row 2 tuple status unknown ok 276 - row 4 tuple status unknown ok 277 - row 0 p1 data ok 278 - row 0 p2 data ok 279 - row 1 p1 data ok 280 - row 1 p2 data ok 281 - row 2 p1 data ok 282 - row 2 p2 data ok 283 - row 3 p1 data ok 284 - row 3 p2 data # error tests array_context = 0, raise = 0 # Last row in error # insert array_context = 0, error = 1, affected = undef, tuple = ARRAY(0x2de6ff0), raise = 0, sts = undef, commit = 0 # ***** error handler called ***** ok 285 - no error in execute_array eval ok 286 - execute_array returned undef rows executed # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # [ # 1, # 'ORA-00001: unique constraint (TEST.SYS_C0019584) violated (DBD SUCCESS_WITH_INFO)', # 'S1000' # ] # ]; ok 287 - tuple status is an array ok 288 - status arrays same size ok 289 - row 0 tuple status unknown ok 290 - row 1 tuple status unknown ok 291 - row 2 tuple status unknown ok 292 - row 3 tuple status unknown ok 293 - row 0 p1 data ok 294 - row 0 p2 data ok 295 - row 1 p1 data ok 296 - row 1 p2 data ok 297 - row 2 p1 data ok 298 - row 2 p2 data ok 299 - row 3 p1 data ok 300 - row 3 p2 data # 2nd last row in error # insert tuple = ARRAY(0x2dee1b0), raise = 0, sts = undef, commit = 0, array_context = 0, error = 1, affected = undef # ***** error handler called ***** ok 301 - no error in execute_array eval ok 302 - execute_array returned undef rows executed # $ArrayTupleStatus = [ # -1, # -1, # -1, # [ # 1, # 'ORA-00001: unique constraint (TEST.SYS_C0019584) violated (DBD SUCCESS_WITH_INFO)', # 'S1000' # ], # -1 # ]; ok 303 - tuple status is an array ok 304 - status arrays same size ok 305 - row 0 tuple status unknown ok 306 - row 1 tuple status unknown ok 307 - row 2 tuple status unknown ok 308 - row 4 tuple status unknown ok 309 - row 0 p1 data ok 310 - row 0 p2 data ok 311 - row 1 p1 data ok 312 - row 1 p2 data ok 313 - row 2 p1 data ok 314 - row 2 p2 data ok 315 - row 3 p1 data ok 316 - row 3 p2 data # row_size via execute_for_fetch # insert affected = 5, fetch = CODE(0x2bbc998), raise = 1, sts = 5, array_context = 1, error = 0, tuple = ARRAY(0x2dec760), commit = 0 # fetch_sub 0 # fetch_sub 1 # fetch_sub 2 # fetch_sub 3 # fetch_sub 4 # fetch_sub 5 # returning undef ok 317 - no error in execute_array eval ok 318 - execute_array returned 5 rows executed ok 319 - total affected 5 ok 320 - no error captured ok 321 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 322 - tuple status is an array ok 323 - status arrays same size ok 324 - row 0 tuple status unknown ok 325 - row 1 tuple status unknown ok 326 - row 2 tuple status unknown ok 327 - row 3 tuple status unknown ok 328 - row 4 tuple status unknown # row_size via select ok 329 - execute on second table ok 330 - second statement is in executed state # insert array_context = 1, error = 0, tuple = ARRAY(0x2dee360), commit = 0, affected = 5, requires_mas = 1, fetch = DBI::st=HASH(0x2dee8b8), raise = 1, sts = 5 ok 331 - no error in execute_array eval ok 332 - execute_array returned 5 rows executed ok 333 - total affected 5 ok 334 - no error captured ok 335 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 336 - tuple status is an array ok 337 - status arrays same size ok 338 - row 0 tuple status unknown ok 339 - row 1 tuple status unknown ok 340 - row 2 tuple status unknown ok 341 - row 3 tuple status unknown ok 342 - row 4 tuple status unknown ok 343 - row 0 p1 data ok 344 - row 0 p2 data ok 345 - row 1 p1 data ok 346 - row 1 p2 data ok 347 - row 2 p1 data ok 348 - row 2 p2 data ok 349 - row 3 p1 data ok 350 - row 3 p2 data ok 351 - row 4 p1 data ok 352 - row 4 p2 data # update test # insert raise = 1, sts = 5, affected = 5, fetch = CODE(0x2bbc998), tuple = ARRAY(0x2df0578), commit = 0, array_context = 1, error = 0 # fetch_sub 0 # fetch_sub 1 # fetch_sub 2 # fetch_sub 3 # fetch_sub 4 # fetch_sub 5 # returning undef ok 353 - no error in execute_array eval ok 354 - execute_array returned 5 rows executed ok 355 - total affected 5 ok 356 - no error captured ok 357 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 358 - tuple status is an array ok 359 - status arrays same size ok 360 - row 0 tuple status unknown ok 361 - row 1 tuple status unknown ok 362 - row 2 tuple status unknown ok 363 - row 3 tuple status unknown ok 364 - row 4 tuple status unknown ok 365 - row 0 p1 data ok 366 - row 0 p2 data ok 367 - row 1 p1 data ok 368 - row 1 p2 data ok 369 - row 2 p1 data ok 370 - row 2 p2 data ok 371 - row 3 p1 data ok 372 - row 3 p2 data ok 373 - row 4 p1 data ok 374 - row 4 p2 data # insert sts = 5, commit = 0, raise = 1, tuple = ARRAY(0x2df04a0), array_context = 1, affected = 5, error = 0 ok 375 - no error in execute_array eval ok 376 - execute_array returned 5 rows executed ok 377 - total affected 5 ok 378 - no error captured ok 379 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 380 - tuple status is an array ok 381 - status arrays same size ok 382 - row 0 tuple status unknown ok 383 - row 1 tuple status unknown ok 384 - row 2 tuple status unknown ok 385 - row 3 tuple status unknown ok 386 - row 4 tuple status unknown ok 387 - row 0 p1 data ok 388 - row 0 p2 data ok 389 - row 1 p1 data ok 390 - row 1 p2 data ok 391 - row 2 p1 data ok 392 - row 2 p2 data ok 393 - row 3 p1 data ok 394 - row 3 p2 data ok 395 - row 4 p1 data ok 396 - row 4 p2 data # insert raise = 1, tuple = ARRAY(0x2df00b0), sts = 5, commit = 0, array_context = 1, error = 0, affected = 4 ok 397 - no error in execute_array eval ok 398 - execute_array returned 5 rows executed ok 399 - total affected 4 ok 400 - no error captured ok 401 - 5 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1, # -1, # -1, # -1 # ]; ok 402 - tuple status is an array ok 403 - status arrays same size ok 404 - row 0 tuple status unknown ok 405 - row 1 tuple status unknown ok 406 - row 2 tuple status unknown ok 407 - row 3 tuple status unknown ok 408 - row 4 tuple status unknown ok 409 - row 0 p1 data ok 410 - row 0 p2 data ok 411 - row 1 p1 data ok 412 - row 1 p2 data ok 413 - row 2 p1 data ok 414 - row 2 p2 data ok 415 - row 3 p1 data ok 416 - row 3 p2 data ok 417 - row 4 p1 data ok 418 - row 4 p2 data # insert commit = 0, sts = 2, tuple = ARRAY(0x2dec1a8), raise = 1, array_context = 1, affected = 5, error = 0 ok 419 - no error in execute_array eval ok 420 - execute_array returned 2 rows executed ok 421 - total affected 5 ok 422 - no error captured ok 423 - 2 rows in tuple_status # $ArrayTupleStatus = [ # -1, # -1 # ]; ok 424 - tuple status is an array ok 425 - status arrays same size ok 426 - row 0 tuple status unknown ok 427 - row 1 tuple status unknown ok 428 - row 0 p1 data ok 429 - row 0 p2 data ok 430 - row 1 p1 data ok 431 - row 1 p2 data ok 432 - row 2 p1 data ok 433 - row 2 p2 data ok 434 - row 3 p1 data ok 435 - row 3 p2 data ok 436 - row 4 p1 data ok 437 - row 4 p2 data # error tests array_context = 0, notuplestatus = 1, raise = 0 # Last row in error # insert affected = undef, raise = 0, notuplestatus = 1, sts = undef, array_context = 0, error = 1, tuple = ARRAY(0x2df30e0), commit = 0 # ***** error handler called ***** ok 438 - no error in execute_array eval ok 439 - execute_array returned undef rows executed ok 440 - row 0 p1 data ok 441 - row 0 p2 data ok 442 - row 1 p1 data ok 443 - row 1 p2 data ok 444 - row 2 p1 data ok 445 - row 2 p2 data ok 446 - row 3 p1 data ok 447 - row 3 p2 data # 2nd last row in error # insert commit = 0, tuple = ARRAY(0x2e06e10), array_context = 0, error = 1, sts = undef, notuplestatus = 1, raise = 0, affected = undef # ***** error handler called ***** ok 448 - no error in execute_array eval ok 449 - execute_array returned undef rows executed ok 450 - row 0 p1 data ok 451 - row 0 p2 data ok 452 - row 1 p1 data ok 453 - row 1 p2 data ok 454 - row 2 p1 data ok 455 - row 2 p2 data ok 456 - row 3 p1 data ok 457 - row 3 p2 data # error tests array_context = 1, raise = 0, notuplestatus = 1 # Last row in error # insert affected = undef, sts = undef, raise = 0, notuplestatus = 1, array_context = 1, error = 1, commit = 0, tuple = ARRAY(0x2e080e0) # ***** error handler called ***** ok 458 - no error in execute_array eval ok 459 - execute_array returned undef rows executed ok 460 - total affected undef ok 461 - row 0 p1 data ok 462 - row 0 p2 data ok 463 - row 1 p1 data ok 464 - row 1 p2 data ok 465 - row 2 p1 data ok 466 - row 2 p2 data ok 467 - row 3 p1 data ok 468 - row 3 p2 data # 2nd last row in error # insert affected = undef, raise = 0, notuplestatus = 1, sts = undef, array_context = 1, error = 1, tuple = ARRAY(0x2e08cb0), commit = 0 # ***** error handler called ***** ok 469 - no error in execute_array eval ok 470 - execute_array returned undef rows executed ok 471 - total affected undef ok 472 - row 0 p1 data ok 473 - row 0 p2 data ok 474 - row 1 p1 data ok 475 - row 1 p2 data ok 476 - row 2 p1 data ok 477 - row 2 p2 data ok 478 - row 3 p1 data ok 479 - row 3 p2 data # error tests array_context = 0, raise = 1, notuplestatus = 1 # Last row in error # insert commit = 0, tuple = ARRAY(0x2e0af90), array_context = 0, error = 1, sts = undef, raise = 1, notuplestatus = 1, affected = undef # ***** error handler called ***** ok 480 - error in execute_array eval ok 481 - error captured ok 482 - row 0 p1 data ok 483 - row 0 p2 data ok 484 - row 1 p1 data ok 485 - row 1 p2 data ok 486 - row 2 p1 data ok 487 - row 2 p2 data ok 488 - row 3 p1 data ok 489 - row 3 p2 data # 2nd last row in error # insert sts = undef, raise = 1, notuplestatus = 1, affected = undef, commit = 0, tuple = ARRAY(0x2e0bb60), array_context = 0, error = 1 # ***** error handler called ***** ok 490 - error in execute_array eval ok 491 - error captured ok 492 - row 0 p1 data ok 493 - row 0 p2 data ok 494 - row 1 p1 data ok 495 - row 1 p2 data ok 496 - row 2 p1 data ok 497 - row 2 p2 data ok 498 - row 3 p1 data ok 499 - row 3 p2 data # error tests array_context = 1, raise = 1, notuplestatus = 1 # Last row in error # insert affected = undef, raise = 1, notuplestatus = 1, sts = undef, error = 1, array_context = 1, tuple = ARRAY(0x2e0bde8), commit = 0 # ***** error handler called ***** ok 500 - error in execute_array eval ok 501 - error captured ok 502 - row 0 p1 data ok 503 - row 0 p2 data ok 504 - row 1 p1 data ok 505 - row 1 p2 data ok 506 - row 2 p1 data ok 507 - row 2 p2 data ok 508 - row 3 p1 data ok 509 - row 3 p2 data # 2nd last row in error # insert affected = undef, raise = 1, notuplestatus = 1, sts = undef, array_context = 1, error = 1, tuple = ARRAY(0x2e0c948), commit = 0 # ***** error handler called ***** ok 510 - error in execute_array eval ok 511 - error captured ok 512 - row 0 p1 data ok 513 - row 0 p2 data ok 514 - row 1 p1 data ok 515 - row 1 p2 data ok 516 - row 2 p1 data ok 517 - row 2 p2 data ok 518 - row 3 p1 data ok 519 - row 3 p2 data # Table dropped ok 520 - no warnings 1..520 ok t/28array_bind.t .............. # set $ENV{NLS_LANG='AMERICAN_AMERICA.AL32UTF8' 1..15 ok 1 - VARCHAR2_TABLE input count correctness ok 2 - VARCHAR2_TABLE output count correctness ok 3 - VARCHAR2_TABLE output content ok 4 - NUMBER_TABLE input count correctness ok 5 - NUMBER_TABLE output count correctness ok 6 - NUMBER_TABLE output content ok 7 - ... bind_param_inout_array should return false ok 8 - ... execute_array should return false ok 9 - ... we should have 19 tuple_status ok 10 - ... we should have 5 out_array ok 11 - ... out values should match 1 ok 12 - ... out values should match 2 ok 13 - ... out values should match 3 ok 14 - ... out values should match 3 ok 15 - ... out values should match 5 ok t/30long.t .................... 1..479 # ora_server_version: 11 2 0 2 0 # Database 11.2.0.2.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is AL16UTF16 (Unicode) # Client 11.2.0.1 NLS_LANG is '', NLS_NCHAR is '' # # ========================================================================= # Running long test for LONG (0) use_utf8_data=0 # create table dbd_ora__drop_mecpanfly52264 ( idx integer, lng LONG, dt date ) # long_data[0] length 10240 # long_data[1] length 81920 # long_data[2] length 71680 # --- insert some LONG data (ora_type 0) ok 1 - prepare: insert into dbd_ora__drop_mecpanfly52264 values (?, ?, SYSDATE) ok 2 - insert long data 40 ok 3 - insert long data 41 ok 4 - insert long data 42 ok 5 - insert long data undef 43 # --- fetch LONG data back again -- truncated - LongTruncOk == 1 # LongReadLen 20, LongTruncOk 1 ok 6 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 7 - execute: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 8 - fetch_arrayref for select * from dbd_ora__drop_mecpanfly52264 order by idx ok 9 - four rows ok 10 - byte_string test of truncated to LongReadLen 20 ok 11 - nice_string test of truncated to LongReadLen 20 ok 12 - LONG UTF8 setting ok 13 - byte_string test of truncated to LongReadLen 20 ok 14 - nice_string test of truncated to LongReadLen 20 ok 15 - LONG UTF8 setting ok 16 - byte_string test of truncated to LongReadLen 20 ok 17 - nice_string test of truncated to LongReadLen 20 ok 18 - LONG UTF8 setting ok 19 - last row undefined # --- fetch LONG data back again -- truncated - LongTruncOk == 0 # LongReadLen 81910, LongTruncOk ok 20 - prepare select * from dbd_ora__drop_mecpanfly52264 order by idx ok 21 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 22 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 23 - length tmp->[1] 10240 ok 24 - truncation error not triggered (LongReadLen 81910, data 10240) ok 25 - tmp==1406 || tmp==24345 tmp actually=24345 # --- fetch LONG data back again -- complete - LongTruncOk == 0 # LongReadLen 82920, LongTruncOk ok 26 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 27 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 28 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 29 - Strings are identical, Len 10240 ok 30 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 31 - Strings are identical, Len 81920 ok 32 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 33 - Strings are identical, Len 71680 ok 34 # skip blob_read tests for LONGs - not currently supported ok 35 # skip blob_read tests for LONGs - not currently supported ok 36 # skip blob_read tests for LONGs - not currently supported ok 37 # skip blob_read tests for LONGs - not currently supported ok 38 # skip blob_read tests for LONGs - not currently supported ok 39 # skip blob_read tests for LONGs - not currently supported ok 40 # skip blob_read tests for LONGs - not currently supported ok 41 # skip blob_read tests for LONGs - not currently supported ok 42 # skip blob_read tests for LONGs - not currently supported ok 43 # skip blob_read tests for LONGs - not currently supported ok 44 # skip blob_read tests for LONGs - not currently supported ok 45 # skip blob_read tests for LONGs - not currently supported ok 46 # skip blob_read tests for LONGs - not currently supported ok 47 # skip blob_read tests for LONGs - not currently supported ok 48 # skip blob_read tests for LONGs - not currently supported ok 49 # skip ora_auto_lob tests for LONGs - not supported ok 50 # skip ora_auto_lob tests for LONGs - not supported ok 51 # skip ora_auto_lob tests for LONGs - not supported ok 52 # skip ora_auto_lob tests for LONGs - not supported ok 53 # skip ora_auto_lob tests for LONGs - not supported ok 54 # skip ora_auto_lob tests for LONGs - not supported ok 55 # skip ora_auto_lob tests for LONGs - not supported ok 56 # skip ora_auto_lob tests for LONGs - not supported ok 57 # skip ora_auto_lob tests for LONGs - not supported ok 58 # skip ora_auto_lob tests for LONGs - not supported ok 59 # skip ora_auto_lob tests for LONGs - not supported ok 60 # skip ora_auto_lob tests for LONGs - not supported ok 61 # skip ora_auto_lob tests for LONGs - not supported ok 62 # skip ora_auto_lob tests for LONGs - not supported ok 63 # skip ora_auto_lob tests for LONGs - not supported ok 64 # skip ora_auto_lob tests for LONGs - not supported ok 65 # skip ora_auto_lob tests for LONGs - not supported ok 66 # skip ora_auto_lob tests for LONGs - not supported ok 67 # skip ora_auto_lob tests for LONGs - not supported ok 68 # skip ora_auto_lob tests for LONGs - not supported ok 69 # skip ora_auto_lob tests for LONGs - not supported ok 70 # skip ora_auto_lob tests for LONGs - not supported ok 71 # skip ora_auto_lob tests for LONGs - not supported ok 72 # skip ora_auto_lob tests for LONGs - not supported ok 73 # skip ora_auto_lob tests for LONGs - not supported ok 74 # skip ora_auto_lob tests for LONGs - not supported ok 75 # skip ora_auto_lob tests for LONGs - not supported ok 76 # skip ora_auto_lob tests for LONGs - not supported ok 77 # skip ora_auto_lob tests for LONGs - not supported ok 78 # skip ora_auto_lob tests for LONGs - not supported ok 79 # skip ora_auto_lob tests for LONGs - not supported ok 80 # skip ora_auto_lob tests for LONGs - not supported ok 81 # skip ora_auto_lob tests for LONGs - not supported ok 82 # skip ora_auto_lob tests for LONGs - not supported ok 83 # skip ora_auto_lob tests for LONGs - not supported ok 84 # skip ora_auto_lob tests for LONGs - not supported ok 85 # skip ora_auto_lob tests for LONGs - not supported ok 86 # skip ora_auto_lob tests for LONGs - not supported ok 87 # skip ora_auto_lob tests for LONGs - not supported ok 88 # skip ora_auto_lob tests for LONGs - not supported ok 89 # skip ora_auto_lob tests for LONGs - not supported ok 90 # skip ora_auto_lob tests for LONGs - not supported ok 91 # skip ora_auto_lob tests for LONGs - not supported ok 92 # skip ora_auto_lob tests for LONGs - not supported ok 93 # skip ora_auto_lob tests for LONGs - not supported ok 94 # skip ora_auto_lob tests for LONGs - not supported # # ========================================================================= # Running long test for LONG RAW (24) use_utf8_data=0 # create table dbd_ora__drop_mecpanfly52264 ( idx integer, lng LONG RAW, dt date ) # long_data[0] length 20480 # long_data[1] length 81920 # long_data[2] length 71680 # --- insert some LONG RAW data (ora_type 24) ok 95 - prepare: insert into dbd_ora__drop_mecpanfly52264 values (?, ?, SYSDATE) ok 96 - insert long data 40 ok 97 - insert long data 41 ok 98 - insert long data 42 ok 99 - insert long data undef 43 # --- fetch LONG RAW data back again -- truncated - LongTruncOk == 1 # LongReadLen 20, LongTruncOk 1 ok 100 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 101 - execute: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 102 - fetch_arrayref for select * from dbd_ora__drop_mecpanfly52264 order by idx ok 103 - four rows ok 104 - byte_string test of truncated to LongReadLen 40 ok 105 - nice_string test of truncated to LongReadLen 40 ok 106 - LONG RAW UTF8 setting ok 107 - byte_string test of truncated to LongReadLen 40 ok 108 - nice_string test of truncated to LongReadLen 40 ok 109 - LONG RAW UTF8 setting ok 110 - byte_string test of truncated to LongReadLen 40 ok 111 - nice_string test of truncated to LongReadLen 40 ok 112 - LONG RAW UTF8 setting ok 113 - last row undefined # --- fetch LONG RAW data back again -- truncated - LongTruncOk == 0 # LongReadLen 40955, LongTruncOk ok 114 - prepare select * from dbd_ora__drop_mecpanfly52264 order by idx ok 115 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 116 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 117 - length tmp->[1] 20480 ok 118 - truncation error not triggered (LongReadLen 40955, data 20480) ok 119 - tmp==1406 || tmp==24345 tmp actually=24345 # --- fetch LONG RAW data back again -- complete - LongTruncOk == 0 # LongReadLen 82920, LongTruncOk ok 120 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 121 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 122 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 123 - Strings are identical, Len 20480 ok 124 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 125 - Strings are identical, Len 81920 ok 126 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 127 - Strings are identical, Len 71680 ok 128 # skip blob_read tests for LONGs - not currently supported ok 129 # skip blob_read tests for LONGs - not currently supported ok 130 # skip blob_read tests for LONGs - not currently supported ok 131 # skip blob_read tests for LONGs - not currently supported ok 132 # skip blob_read tests for LONGs - not currently supported ok 133 # skip blob_read tests for LONGs - not currently supported ok 134 # skip blob_read tests for LONGs - not currently supported ok 135 # skip blob_read tests for LONGs - not currently supported ok 136 # skip blob_read tests for LONGs - not currently supported ok 137 # skip blob_read tests for LONGs - not currently supported ok 138 # skip blob_read tests for LONGs - not currently supported ok 139 # skip blob_read tests for LONGs - not currently supported ok 140 # skip blob_read tests for LONGs - not currently supported ok 141 # skip blob_read tests for LONGs - not currently supported ok 142 # skip blob_read tests for LONGs - not currently supported ok 143 # skip ora_auto_lob tests for LONG RAWs - not supported ok 144 # skip ora_auto_lob tests for LONG RAWs - not supported ok 145 # skip ora_auto_lob tests for LONG RAWs - not supported ok 146 # skip ora_auto_lob tests for LONG RAWs - not supported ok 147 # skip ora_auto_lob tests for LONG RAWs - not supported ok 148 # skip ora_auto_lob tests for LONG RAWs - not supported ok 149 # skip ora_auto_lob tests for LONG RAWs - not supported ok 150 # skip ora_auto_lob tests for LONG RAWs - not supported ok 151 # skip ora_auto_lob tests for LONG RAWs - not supported ok 152 # skip ora_auto_lob tests for LONG RAWs - not supported ok 153 # skip ora_auto_lob tests for LONG RAWs - not supported ok 154 # skip ora_auto_lob tests for LONG RAWs - not supported ok 155 # skip ora_auto_lob tests for LONG RAWs - not supported ok 156 # skip ora_auto_lob tests for LONG RAWs - not supported ok 157 # skip ora_auto_lob tests for LONG RAWs - not supported ok 158 # skip ora_auto_lob tests for LONG RAWs - not supported ok 159 # skip ora_auto_lob tests for LONG RAWs - not supported ok 160 # skip ora_auto_lob tests for LONG RAWs - not supported ok 161 # skip ora_auto_lob tests for LONG RAWs - not supported ok 162 # skip ora_auto_lob tests for LONG RAWs - not supported ok 163 # skip ora_auto_lob tests for LONG RAWs - not supported ok 164 # skip ora_auto_lob tests for LONG RAWs - not supported ok 165 # skip ora_auto_lob tests for LONG RAWs - not supported ok 166 # skip ora_auto_lob tests for LONG RAWs - not supported ok 167 # skip ora_auto_lob tests for LONG RAWs - not supported ok 168 # skip ora_auto_lob tests for LONG RAWs - not supported ok 169 # skip ora_auto_lob tests for LONG RAWs - not supported ok 170 # skip ora_auto_lob tests for LONG RAWs - not supported ok 171 # skip ora_auto_lob tests for LONG RAWs - not supported ok 172 # skip ora_auto_lob tests for LONG RAWs - not supported ok 173 # skip ora_auto_lob tests for LONG RAWs - not supported ok 174 # skip ora_auto_lob tests for LONG RAWs - not supported ok 175 # skip ora_auto_lob tests for LONG RAWs - not supported ok 176 # skip ora_auto_lob tests for LONG RAWs - not supported ok 177 # skip ora_auto_lob tests for LONG RAWs - not supported ok 178 # skip ora_auto_lob tests for LONG RAWs - not supported ok 179 # skip ora_auto_lob tests for LONG RAWs - not supported ok 180 # skip ora_auto_lob tests for LONG RAWs - not supported ok 181 # skip ora_auto_lob tests for LONG RAWs - not supported ok 182 # skip ora_auto_lob tests for LONG RAWs - not supported ok 183 # skip ora_auto_lob tests for LONG RAWs - not supported ok 184 # skip ora_auto_lob tests for LONG RAWs - not supported ok 185 # skip ora_auto_lob tests for LONG RAWs - not supported ok 186 # skip ora_auto_lob tests for LONG RAWs - not supported ok 187 # skip ora_auto_lob tests for LONG RAWs - not supported ok 188 # skip ora_auto_lob tests for LONG RAWs - not supported # # ========================================================================= # Running long test for NCLOB (112) use_utf8_data=0 # create table dbd_ora__drop_mecpanfly52264 ( idx integer, lng NCLOB, dt date ) # long_data[0] length 10240 # long_data[1] length 81920 # long_data[2] length 71680 # --- insert some NCLOB data (ora_type 112) ok 189 - prepare: insert into dbd_ora__drop_mecpanfly52264 values (?, ?, SYSDATE) ok 190 - insert long data 40 ok 191 - insert long data 41 ok 192 - insert long data 42 ok 193 - insert long data undef 43 # --- fetch NCLOB data back again -- truncated - LongTruncOk == 1 # LongReadLen 20, LongTruncOk 1 ok 194 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 195 - execute: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 196 - fetch_arrayref for select * from dbd_ora__drop_mecpanfly52264 order by idx ok 197 - four rows ok 198 - byte_string test of truncated to LongReadLen 20 ok 199 - nice_string test of truncated to LongReadLen 20 ok 200 - NCLOB UTF8 setting ok 201 - byte_string test of truncated to LongReadLen 20 ok 202 - nice_string test of truncated to LongReadLen 20 ok 203 - NCLOB UTF8 setting ok 204 - byte_string test of truncated to LongReadLen 20 ok 205 - nice_string test of truncated to LongReadLen 20 ok 206 - NCLOB UTF8 setting ok 207 - last row undefined # --- fetch NCLOB data back again -- truncated - LongTruncOk == 0 # LongReadLen 81910, LongTruncOk ok 208 - prepare select * from dbd_ora__drop_mecpanfly52264 order by idx ok 209 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 210 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 211 - length tmp->[1] 10240 ok 212 - truncation error not triggered (LongReadLen 81910, data 1) ok 213 - tmp==1406 || tmp==24345 tmp actually=24345 # --- fetch NCLOB data back again -- complete - LongTruncOk == 0 # LongReadLen 82920, LongTruncOk ok 214 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 215 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 216 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 217 - Strings are identical, Len 10240 ok 218 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 219 - Strings are identical, Len 81920 ok 220 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 221 - Strings are identical, Len 71680 # --- fetch NCLOB data back again -- via blob_read # ok 222 - prepare select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 223 - execute select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx # fetch via fetchrow_arrayref ok 224 - fetchrow_arrayref 1: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 225 - byte_string test of truncated to LongReadLen 20 ok 226 - nice_string test of truncated to LongReadLen 20 # read via blob_read_all ok 227 - blob_read_all = length($long_data[0]) ok 228 - Strings are identical ok 229 - fetchrow_arrayref 2: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 230 - blob_read_all = length(long_data[1]) ok 231 - Strings are identical ok 232 - fetchrow_arrayref 3: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 233 - length of long_data[2] = 71680 ok 234 - byte_string test of 3rd row via blob_read_all ok 235 - nice_string test of 3rd row via blob_read_all # result is non-UTF8 ok 236 - result should not be utf8 # --- testing ora_auto_lob to access NCLOB LobLocator # ok 237 - prepare # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # ok 238 - execute # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40: OCILobLocatorPtr=SCALAR(0x79c6ab8) ok 239 - $lob_locator is true ok 240 - $lob_locator is a OCILobLocatorPtr ok 241 - $lob_locator deref ptr is true ok 242 - DBI::errstr # length of data to be written at offset 1: 8 ok 243 - ora_lob_write # 41: OCILobLocatorPtr=SCALAR(0x79c6dd0) ok 244 - $lob_locator is true ok 245 - $lob_locator is a OCILobLocatorPtr ok 246 - $lob_locator deref ptr is true ok 247 - DBI::errstr # length of data to be written at offset 1: 8 ok 248 - ora_lob_write # 42: OCILobLocatorPtr=SCALAR(0x79c6ab8) ok 249 - $lob_locator is true ok 250 - $lob_locator is a OCILobLocatorPtr ok 251 - $lob_locator deref ptr is true ok 252 - DBI::errstr # length of data to be written at offset 1: 8 ok 253 - ora_lob_write # 43: undef ok 254 # --- round again to check contents after NCLOB write updates... ok 255 - execute (again 1) # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40 locator: OCILobLocatorPtr=SCALAR(0x79c6ab8) ok 256 - content is true # 40 content: 040 foo!\x00X0\x7Fx\x00X0\x7Fx\x00X ok 257 - lenth(content) ok 258 - length(content)=length(data) ok 259 - DBI::errstr ok 260 - length(long_data{idx}) = length of locator data ok 261 - DBI::errstr ok 262 - ora_lob_append DBI::errstr # 41 locator: OCILobLocatorPtr=SCALAR(0x79ccb90) ok 263 - content is true # 41 content: 041 foo!901234567890 ok 264 - lenth(content) ok 265 - length(content)=length(data) ok 266 - DBI::errstr ok 267 - length(long_data{idx}) = length of locator data ok 268 - DBI::errstr ok 269 - ora_lob_append DBI::errstr # 42 locator: OCILobLocatorPtr=SCALAR(0x79c6ab8) ok 270 - content is true # 42 content: 042 foo!cd2bcdefabcd ok 271 - lenth(content) ok 272 - length(content)=length(data) ok 273 - DBI::errstr ok 274 - length(long_data{idx}) = length of locator data ok 275 - DBI::errstr ok 276 - ora_lob_append DBI::errstr # 43 locator: undef ok 277 # --- round again to check the NCLOB length... ok 278 - execute (again 2) # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40 locator: OCILobLocatorPtr=SCALAR(0x79c6ab8) ok 279 - DBI::errstr ok 280 - len == idx+5 # 41 locator: OCILobLocatorPtr=SCALAR(0x79ccb90) ok 281 - DBI::errstr ok 282 - len == idx+5 # 42 locator: OCILobLocatorPtr=SCALAR(0x79c6ab8) ok 283 - DBI::errstr ok 284 - len == idx+5 # 43 locator: undef ok 285 # # ========================================================================= # Running long test for CLOB (112) use_utf8_data=0 # create table dbd_ora__drop_mecpanfly52264 ( idx integer, lng CLOB, dt date ) # long_data[0] length 10240 # long_data[1] length 81920 # long_data[2] length 71680 # --- insert some CLOB data (ora_type 112) ok 286 - prepare: insert into dbd_ora__drop_mecpanfly52264 values (?, ?, SYSDATE) ok 287 - insert long data 40 ok 288 - insert long data 41 ok 289 - insert long data 42 ok 290 - insert long data undef 43 # --- fetch CLOB data back again -- truncated - LongTruncOk == 1 # LongReadLen 20, LongTruncOk 1 ok 291 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 292 - execute: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 293 - fetch_arrayref for select * from dbd_ora__drop_mecpanfly52264 order by idx ok 294 - four rows ok 295 - byte_string test of truncated to LongReadLen 20 ok 296 - nice_string test of truncated to LongReadLen 20 ok 297 - CLOB UTF8 setting ok 298 - byte_string test of truncated to LongReadLen 20 ok 299 - nice_string test of truncated to LongReadLen 20 ok 300 - CLOB UTF8 setting ok 301 - byte_string test of truncated to LongReadLen 20 ok 302 - nice_string test of truncated to LongReadLen 20 ok 303 - CLOB UTF8 setting ok 304 - last row undefined # --- fetch CLOB data back again -- truncated - LongTruncOk == 0 # LongReadLen 81910, LongTruncOk ok 305 - prepare select * from dbd_ora__drop_mecpanfly52264 order by idx ok 306 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 307 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 308 - length tmp->[1] 10240 ok 309 - truncation error not triggered (LongReadLen 81910, data 1) ok 310 - tmp==1406 || tmp==24345 tmp actually=24345 # --- fetch CLOB data back again -- complete - LongTruncOk == 0 # LongReadLen 82920, LongTruncOk ok 311 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 312 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 313 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 314 - Strings are identical, Len 10240 ok 315 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 316 - Strings are identical, Len 81920 ok 317 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 318 - Strings are identical, Len 71680 # --- fetch CLOB data back again -- via blob_read # ok 319 - prepare select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 320 - execute select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx # fetch via fetchrow_arrayref ok 321 - fetchrow_arrayref 1: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 322 - byte_string test of truncated to LongReadLen 20 ok 323 - nice_string test of truncated to LongReadLen 20 # read via blob_read_all ok 324 - blob_read_all = length($long_data[0]) ok 325 - Strings are identical ok 326 - fetchrow_arrayref 2: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 327 - blob_read_all = length(long_data[1]) ok 328 - Strings are identical ok 329 - fetchrow_arrayref 3: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 330 - length of long_data[2] = 71680 ok 331 - byte_string test of 3rd row via blob_read_all ok 332 - nice_string test of 3rd row via blob_read_all # result is non-UTF8 ok 333 - result should not be utf8 # --- testing ora_auto_lob to access CLOB LobLocator # ok 334 - prepare # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # ok 335 - execute # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40: OCILobLocatorPtr=SCALAR(0x329b1e0) ok 336 - $lob_locator is true ok 337 - $lob_locator is a OCILobLocatorPtr ok 338 - $lob_locator deref ptr is true ok 339 - DBI::errstr # length of data to be written at offset 1: 8 ok 340 - ora_lob_write # 41: OCILobLocatorPtr=SCALAR(0x329b0d8) ok 341 - $lob_locator is true ok 342 - $lob_locator is a OCILobLocatorPtr ok 343 - $lob_locator deref ptr is true ok 344 - DBI::errstr # length of data to be written at offset 1: 8 ok 345 - ora_lob_write # 42: OCILobLocatorPtr=SCALAR(0x329b1e0) ok 346 - $lob_locator is true ok 347 - $lob_locator is a OCILobLocatorPtr ok 348 - $lob_locator deref ptr is true ok 349 - DBI::errstr # length of data to be written at offset 1: 8 ok 350 - ora_lob_write # 43: undef ok 351 # --- round again to check contents after CLOB write updates... ok 352 - execute (again 1) # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40 locator: OCILobLocatorPtr=SCALAR(0x329b1e0) ok 353 - content is true # 40 content: 040 foo!\x00X0\x7Fx\x00X0\x7Fx\x00X ok 354 - lenth(content) ok 355 - length(content)=length(data) ok 356 - DBI::errstr ok 357 - length(long_data{idx}) = length of locator data ok 358 - DBI::errstr ok 359 - ora_lob_append DBI::errstr # 41 locator: OCILobLocatorPtr=SCALAR(0x329c190) ok 360 - content is true # 41 content: 041 foo!901234567890 ok 361 - lenth(content) ok 362 - length(content)=length(data) ok 363 - DBI::errstr ok 364 - length(long_data{idx}) = length of locator data ok 365 - DBI::errstr ok 366 - ora_lob_append DBI::errstr # 42 locator: OCILobLocatorPtr=SCALAR(0x329b1e0) ok 367 - content is true # 42 content: 042 foo!cd2bcdefabcd ok 368 - lenth(content) ok 369 - length(content)=length(data) ok 370 - DBI::errstr ok 371 - length(long_data{idx}) = length of locator data ok 372 - DBI::errstr ok 373 - ora_lob_append DBI::errstr # 43 locator: undef ok 374 # --- round again to check the CLOB length... ok 375 - execute (again 2) # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40 locator: OCILobLocatorPtr=SCALAR(0x329b1e0) ok 376 - DBI::errstr ok 377 - len == idx+5 # 41 locator: OCILobLocatorPtr=SCALAR(0x329c190) ok 378 - DBI::errstr ok 379 - len == idx+5 # 42 locator: OCILobLocatorPtr=SCALAR(0x329b1e0) ok 380 - DBI::errstr ok 381 - len == idx+5 # 43 locator: undef ok 382 # # ========================================================================= # Running long test for BLOB (113) use_utf8_data=0 # create table dbd_ora__drop_mecpanfly52264 ( idx integer, lng BLOB, dt date ) # long_data[0] length 10240 # long_data[1] length 81920 # long_data[2] length 71680 # --- insert some BLOB data (ora_type 113) ok 383 - prepare: insert into dbd_ora__drop_mecpanfly52264 values (?, ?, SYSDATE) ok 384 - insert long data 40 ok 385 - insert long data 41 ok 386 - insert long data 42 ok 387 - insert long data undef 43 # --- fetch BLOB data back again -- truncated - LongTruncOk == 1 # LongReadLen 20, LongTruncOk 1 ok 388 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 389 - execute: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 390 - fetch_arrayref for select * from dbd_ora__drop_mecpanfly52264 order by idx ok 391 - four rows ok 392 - byte_string test of truncated to LongReadLen 20 ok 393 - nice_string test of truncated to LongReadLen 20 ok 394 - BLOB non-UTF8 ok 395 - byte_string test of truncated to LongReadLen 20 ok 396 - nice_string test of truncated to LongReadLen 20 ok 397 - BLOB non-UTF8 ok 398 - byte_string test of truncated to LongReadLen 20 ok 399 - nice_string test of truncated to LongReadLen 20 ok 400 - BLOB non-UTF8 ok 401 - last row undefined # --- fetch BLOB data back again -- truncated - LongTruncOk == 0 # LongReadLen 81910, LongTruncOk ok 402 - prepare select * from dbd_ora__drop_mecpanfly52264 order by idx ok 403 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 404 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 405 - length tmp->[1] 10240 ok 406 - truncation error not triggered (LongReadLen 81910, data 1) ok 407 - tmp==1406 || tmp==24345 tmp actually=24345 # --- fetch BLOB data back again -- complete - LongTruncOk == 0 # LongReadLen 82920, LongTruncOk ok 408 - prepare: select * from dbd_ora__drop_mecpanfly52264 order by idx ok 409 - execute select * from dbd_ora__drop_mecpanfly52264 order by idx ok 410 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 411 - Strings are identical, Len 10240 ok 412 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 413 - Strings are identical, Len 81920 ok 414 - fetchrow_arrayref select * from dbd_ora__drop_mecpanfly52264 order by idx ok 415 - Strings are identical, Len 71680 # --- fetch BLOB data back again -- via blob_read # ok 416 - prepare select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 417 - execute select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx # fetch via fetchrow_arrayref ok 418 - fetchrow_arrayref 1: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 419 - byte_string test of truncated to LongReadLen 20 ok 420 - nice_string test of truncated to LongReadLen 20 # read via blob_read_all ok 421 - blob_read_all = length($long_data[0]) ok 422 - Strings are identical ok 423 - fetchrow_arrayref 2: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 424 - blob_read_all = length(long_data[1]) ok 425 - Strings are identical ok 426 - fetchrow_arrayref 3: select idx, lng, dt from dbd_ora__drop_mecpanfly52264 order by idx ok 427 - length of long_data[2] = 71680 ok 428 - byte_string test of 3rd row via blob_read_all ok 429 - nice_string test of 3rd row via blob_read_all # result is non-UTF8 ok 430 - result should not be utf8 # --- testing ora_auto_lob to access BLOB LobLocator # ok 431 - prepare # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # ok 432 - execute # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40: OCILobLocatorPtr=SCALAR(0x2f2f780) ok 433 - $lob_locator is true ok 434 - $lob_locator is a OCILobLocatorPtr ok 435 - $lob_locator deref ptr is true ok 436 - DBI::errstr # length of data to be written at offset 1: 8 ok 437 - ora_lob_write # 41: OCILobLocatorPtr=SCALAR(0x2f2f678) ok 438 - $lob_locator is true ok 439 - $lob_locator is a OCILobLocatorPtr ok 440 - $lob_locator deref ptr is true ok 441 - DBI::errstr # length of data to be written at offset 1: 8 ok 442 - ora_lob_write # 42: OCILobLocatorPtr=SCALAR(0x2f2f780) ok 443 - $lob_locator is true ok 444 - $lob_locator is a OCILobLocatorPtr ok 445 - $lob_locator deref ptr is true ok 446 - DBI::errstr # length of data to be written at offset 1: 8 ok 447 - ora_lob_write # 43: undef ok 448 # --- round again to check contents after BLOB write updates... ok 449 - execute (again 1) # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40 locator: OCILobLocatorPtr=SCALAR(0x2f2f780) ok 450 - content is true # 40 content: 040 foo!\x00X0\x7Fx\x00X0\x7Fx\x00X ok 451 - lenth(content) ok 452 - length(content)=length(data) ok 453 - DBI::errstr ok 454 - length(long_data{idx}) = length of locator data ok 455 - DBI::errstr ok 456 - ora_lob_append DBI::errstr # 41 locator: OCILobLocatorPtr=SCALAR(0x2f30730) ok 457 - content is true # 41 content: 041 foo!901234567890 ok 458 - lenth(content) ok 459 - length(content)=length(data) ok 460 - DBI::errstr ok 461 - length(long_data{idx}) = length of locator data ok 462 - DBI::errstr ok 463 - ora_lob_append DBI::errstr # 42 locator: OCILobLocatorPtr=SCALAR(0x2f2f780) ok 464 - content is true # 42 content: 042 foo!cd2bcdefabcd ok 465 - lenth(content) ok 466 - length(content)=length(data) ok 467 - DBI::errstr ok 468 - length(long_data{idx}) = length of locator data ok 469 - DBI::errstr ok 470 - ora_lob_append DBI::errstr # 43 locator: undef ok 471 # --- round again to check the BLOB length... ok 472 - execute (again 2) # SELECT lng, idx FROM dbd_ora__drop_mecpanfly52264 ORDER BY idx # FOR UPDATE -- needed so lob locator is writable # # 40 locator: OCILobLocatorPtr=SCALAR(0x2f2f780) ok 473 - DBI::errstr ok 474 - len == idx+5 # 41 locator: OCILobLocatorPtr=SCALAR(0x2f30730) ok 475 - DBI::errstr ok 476 - len == idx+5 # 42 locator: OCILobLocatorPtr=SCALAR(0x2f2f780) ok 477 - DBI::errstr ok 478 - len == idx+5 # 43 locator: undef ok 479 ok DBI::db=HASH(0x2b64188)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at t/31lob.t line 216. t/31lob.t ..................... 1..12 ok 1 - returned valid locator ok 2 - inserted into BLOB successfully ok 3 - got back what we put in ok 4 - returned valid locator ok 5 - returned valid locator ok 6 - returned initialized locator ok 7 - returned length ok 8 - returned written value ok 9 - returned length via PL/SQL # TODO problem reported w/ lobs and Oracle 11.2.*, see RT#69350 ok 10 - returned LOB as string # TODO problem reported w/ lobs and Oracle 11.2.*, see RT#69350 ok 11 - returned IN/OUT LOB as string # TODO problem reported w/ lobs and Oracle 11.2.*, see RT#69350 ok 12 # skip can't check num of temp lobs, no access to v$session ok t/31lob_extended.t ............ 1..30 # create table dbd_ora__drop_mecpanfly52264 ( idx integer, x clob, dt date ) ok 1 - created test table ok 2 - created test data ok 3 - ora_auto_lobs prefetch - prepare call proc ok 4 - ora_auto_lobs prefetch - bind out cursor ok 5 - ora_auto_lobs prefetch - execute to get out cursor ok 6 - ora_auto_lobs prefetch - lob locator retrieved ok 7 - ora_auto_lobs prefetch - is a lob locator ok 8 - ora_auto_lobs prefetch - first lob length 6000 ok 9 - ora_auto_lobs prefetch - correct lob length ok 10 - ora_auto_lobs prefetch - read lob ok 11 - ora_auto_lobs prefetch - lob returned matches lob inserted ok 12 - ora_auto_lobs prefetch - lob locator retrieved ok 13 - ora_auto_lobs prefetch - is a lob locator ok 14 - ora_auto_lobs prefetch - first lob length 6000 ok 15 - ora_auto_lobs prefetch - correct lob length ok 16 - ora_auto_lobs prefetch - read lob ok 17 - ora_auto_lobs prefetch - lob returned matches lob inserted ok 18 - ora_auto_lobs prefetch - finished returned sth ok 19 - ora_auto_lobs prefetch - finished sth ok 20 - ora_auto_lobs not fetching prepare call proc ok 21 - ora_auto_lobs not fetching - bind out cursor ok 22 - ora_auto_lobs not fetching - execute to get out cursor ok 23 - ora_auto_lobs not fetching - fetch returns something ok 24 - ora_auto_lobs not fetching - not a lob locator ok 25 - ora_auto_lobs not fetching, first lob matches ok 26 - ora_auto_lobs not fetching - fetch returns something ok 27 - ora_auto_lobs not fetching - not a lob locator ok 28 - ora_auto_lobs not fetching, second lob matches ok 29 - ora_auto_lobs not fetching - finished returned sth ok 30 - ora_auto_lobs not fetching - finished sth ok t/32xmltype.t ................. 1..3 ok 1 - An object of class 'DBI::db' isa 'DBI::db' ok 2 - ... execute for small XML return true ok 3 - ... execute for large XML return true ok t/34pres_lobs.t ............... 1..28 ok 1 - create test table ok 2 - prepare for insert into lobs ok 3 - bind p2 ok 4 - bind p3 ok 5 - bind p4 ok 6 - bind p5 ok 7 - execute ok 8 - prepare with ora_pers_lob ok 9 - execute with ora_pers_lob ok 10 - fetcheow for ora_pers_lob ok 11 - clob1 = in_clob ok 12 - clob2 = in_clob ok 13 - clob1 = in_blob ok 14 - clob2 = in_blob ok 15 - prepare for ora_piece_size ok 16 - execute for ora_piece_size ok 17 - fetchrow ok 18 - clob1 = in_clob ok 19 - clob2 = in_clob ok 20 - clob1 = in_clob ok 21 - clob2 = in_clob ok 22 - prepare with ora_piece_lob/ora_piece_size ok 23 - execute ok 24 - fetchrow ok 25 - clob1 = in_clob ok 26 - clob2 = in_clob ok 27 - clob1 = in_clob ok 28 - clob2 = in_clob ok t/36lob_leak.t ................ 1..7 ok 1 # skip unable to find sid ok 2 # skip unable to find sid ok 3 # skip Cannot find sid/cached lobs ok 4 # skip Cannot find sid/cached lobs ok 5 # skip Cannot find sid/cached lobs ok 6 # skip Cannot find sid/cached lobs ok 7 # skip Cannot find sid/cached lobs ok t/38taf.t ..................... ok 1 - 'You are attempting to enable TAF on a server that is not TAF Enabled # ' (expected) 1..1 ok # Oracle version: 11.2.0.2.0 # client version: 11.2.0.1 t/39attr.t .................... ok 1 - attribute ora_module_name set and retrieved ok 2 - attribute ora_client_info set and retrieved ok 3 - attribute ora_client_identifier set and retrieved ok 4 - attribute ora_action set and retrieved ok 5 - Default driver name ok 6 - attribute ora_module_name set and retrieved ok 7 - attribute ora_client_info set and retrieved ok 8 - attribute ora_client_identifier set and retrieved ok 9 - attribute ora_action set and retrieved ok 10 - attribute ora_oci_success_warn set and retrieved ok 11 - attribute ora_objects set and retrieved 1..11 ok t/40ph_type.t ................. 1..19 ok 1 - create test table # # testing embed_nul 1 chops_space 1 name VARCHAR2 type 1 ... # ok 2 - set ora_ph_type ok 3 - right keys # { # "ts" => { # "isnull" => "trailing ", # "len" => 9, # "vc" => "trailing ", # "c" => "trailing " # }, # "en" => { # "c" => "embedded\0nul ", # "vc" => "embedded\0nul", # "len" => 12, # "isnull" => "embedded\0nul" # }, # "es" => { # "c" => undef, # "len" => undef, # "isnull" => "ISNULL", # "vc" => undef # } # } # 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. ok 4 - using ora_type 1 expected 'trailing' but got 'trailing ' for VARCHAR2 ok 5 - expected 'embedded.nul' but got 'embedded.nul' for VARCHAR2 ok 6 - vc defined ok 7 - c defined ok 8 - len defined ok 9 - ISNULL # # testing type 96 name CHAR embed_nul 1 chops_space 0 ... # ok 10 - set ora_ph_type ok 11 - right keys # { # "es" => { # "vc" => undef, # "isnull" => "ISNULL", # "len" => undef, # "c" => undef # }, # "en" => { # "isnull" => "embedded\0nul", # "len" => 12, # "vc" => "embedded\0nul", # "c" => "embedded\0nul " # }, # "ts" => { # "c" => "trailing ", # "isnull" => "trailing ", # "len" => 9, # "vc" => "trailing " # } # } ok 12 - using ora_type 96 expected 'trailing ' but got 'trailing ' for CHAR ok 13 - expected 'embedded.nul' but got 'embedded.nul' for CHAR ok 14 - vc defined ok 15 - c defined ok 16 - len defined ok 17 - ISNULL ok 18 - drop table ok 19 - disconnect ok Can't determine open_cursors from v$parameter, so using default t/50cursor.t .................. 1..18 # Max cursors: 1 # opening cursors ok 1 - open cursor # opening cursor 1 ok 2 - open cursor bind param inout ok 3 - open cursor execute ok 4 - open cursor Active ok 5 - cursor Active ok 6 - cursor fetcharray ok 7 - cursor fetcharray ok 8 - cursor finish ok 9 - cursor not Active # closing cursors ok 10 - close cursor closing cursor 1 ok 11 - close cursor bind param ok 12 - close cursor execute ok 13 - prepare exec of proc for null cursor ok 14 - binding cursor for null cursor ok 15 - execute for null cursor ok 16 - undef returned for null cursor ok 17 - execute 2 for null cursor ok 18 - undef 2 returned for null cursor ok t/51scroll.t .................. 1..37 ok 1 ok 2 - An object of class 'DBI::db' isa 'DBI::db' ok 3 ok 4 ok 5 - ... we should get the next record ok 6 - ... we should get the next record ok 7 - ... we should get the next record ok 8 - ... we should get the next record ok 9 - ... we should get the next record ok 10 - ... we should get the next record ok 11 - ... we should get the next record ok 12 - ... we should get the next record ok 13 - ... we should get the next record ok 14 - ... we should get the next record ok 15 - ... we should get the 10th record ok 16 - end of result-set ok 17 - ... we should get the prior record ok 18 - ... we should get the prior record ok 19 - ... we should get the prior record ok 20 - ... we should get the prior record ok 21 - ... we should get the prior record ok 22 - ... we should get the prior record ok 23 - ... we should get the prior record ok 24 - ... we should get the prior record ok 25 - ... we should get the prior record ok 26 - ... we should get the 5th record ok 27 - ... we should get the 7th record ok 28 - ... we should get the 4th record ok 29 - ... we should get the 9th record ok 30 - ... we should get the 10th record ok 31 - ... we should get the 10 for the ora_scroll_position ok 32 - ... we should get the 1st record ok 33 - ... we should get the 1 for the ora_scroll_position ok 34 - ... we should get the 3rd record rt76695 ok 35 - ... we should get the 4th record rt 76695 ok 36 - ... we should get the 2nd row rt76410_2 ok 37 - ... we should get the 3rd row rt76410_2 ok t/55nested.t .................. 1..29 ok 1 - prepare select ok 2 - set ORA_RSET ok 3 - outer execute ok 4 - outer fetchrow ok 5 - inner DBI::st ok 6 - inner Active ok 7 - inner fetchrow_array ok 8 - rows equal ok 9 - inner Active ok 10 - outer fetchrow_array ok 11 - inner not Active ok 12 - inner fetch finished ok 13 - err = -1 ok 14 - defunct ok 15 - outer finish ok 16 - ActiveKids ok 17 - prepare select ok 18 - set ORA_RSET ok 19 - set ORA_RSET ok 20 - outer execute ok 21 - outer fetchrow ok 22 - inner DBI::st ok 23 - inner DBI::st ok 24 - inner Active ok 25 - inner Active ok 26 - inner fetchrow_array ok 27 - inner fetchrow_array ok 28 - rows equal ok 29 - rows equal # Fetched 4900 rows (select): 0.046799898147583 secs. # Fetched 4900 rows (nested cursor): 0.046799898147583 secs. ok t/56embbeded.t ................ 1..4 ok 1 - An object of class 'DBI::db' isa 'DBI::db' ok 2 - ... Prepare should return true ok 3 - ... Select should return true ok 4 - ... we should have 5 items ok t/58object.t .................. 1..65 ok 1 - ora_objects flag is set to 1 ok 2 - ora_objects flag is set to 0 ok 3 - An object of class 'DBI::db' isa 'DBI::db' ok 4 - Fetch current schema name ok 5 - CREATE OR REPLACE TYPE dbd_test__type_A AS OBJECT ( # num INTEGER, # name VARCHAR2(20) # ) NOT FINAL ok 6 - CREATE OR REPLACE TYPE dbd_test__type_B UNDER dbd_test__type_A ( # datetime DATE, # amount NUMERIC(10,5) # ) NOT FINAL ok 7 - CREATE TABLE dbd_test__obj_table (id INTEGER, obj dbd_test__type_A) ok 8 - INSERT INTO dbd_test__obj_table VALUES (1, dbd_test__type_A(13, 'obj1')) ok 9 - INSERT INTO dbd_test__obj_table VALUES (2, dbd_test__type_B(NULL, 'obj2', # TO_DATE('2004-11-30 14:27:18', 'YYYY-MM-DD HH24:MI:SS'), # 12345.6789)) ok 10 - INSERT INTO dbd_test__obj_table VALUES (3, dbd_test__type_B(5, 'obj3', NULL, # 777.666)) ok 11 - CREATE OR REPLACE TYPE dbd_test__inner_type AS OBJECT ( # num INTEGER, # name VARCHAR2(20) # ) FINAL ok 12 - CREATE OR REPLACE TYPE dbd_test__outer_type AS OBJECT ( # num INTEGER, # obj dbd_test__inner_type # ) FINAL ok 13 - CREATE OR REPLACE TYPE dbd_test__list_type AS # TABLE OF dbd_test__inner_type ok 14 - CREATE TABLE dbd_test__nest_table(obj dbd_test__outer_type) ok 15 - INSERT INTO dbd_test__nest_table VALUES(dbd_test__outer_type(91, dbd_test__inner_type(1, 'one'))) ok 16 - INSERT INTO dbd_test__nest_table VALUES(dbd_test__outer_type(92, dbd_test__inner_type(0, null))) ok 17 - INSERT INTO dbd_test__nest_table VALUES(dbd_test__outer_type(93, null)) ok 18 - CREATE TABLE dbd_test__list_table ( id INTEGER, list dbd_test__list_type ) # NESTED TABLE list STORE AS dbd_test__list_table_list ok 19 - INSERT INTO dbd_test__list_table VALUES(81,dbd_test__list_type(dbd_test__inner_type(null, 'listed'))) ok 20 - old: Prepare select ok 21 - old: Execute select ok 22 - old: Fetch first row ok 23 - old: Row 1 column 2 is an ARRAY ok 24 - old: Row 1 column 2 is has 2 elements ok 25 - old: Fetch second row ok 26 - old: Row 2 column 2 is an ARRAY ok 27 - old: Row 2 column 2 is has 2 elements ok 28 - old: Fetch third row ok 29 - old: Row 3 column 2 is an ARRAY ok 30 - old: Row 3 column 2 is has 2 elements ok 31 - old: No more rows expected ok 32 - new: Prepare select ok 33 - new: Execute select ok 34 - new: Fetch first row ok 35 - new: Row 1 column 2 is an DBD:Oracle::Object ok 36 - new: Row 1 column 2 object type ok 37 - new: Row 1 column 2 object attributes ok 38 - new: Fetch second row ok 39 - new: Row 2 column 2 is an DBD::Oracle::Object ok 40 - new: Row 2 column 2 object type ok 41 - new: Row 1 column 2 object attributes ok 42 - new: Fetch third row ok 43 - new: Row 3 column 2 is an DBD::Oracle::Object ok 44 - new: Row 3 column 2 object type ok 45 - new: Row 1 column 2 object attributes ok 46 - new: No more rows expected ok 47 - DBD::Oracle::Object->attr_hash ok 48 - DBD::Oracle::Object->attr ok 49 - DBD::Oracle::Object->attr("NAME") ok 50 - new: Prepare select with nested table of objects ok 51 - new: Execute (nested table) ok 52 - new: Fetch first row (nested table) ok 53 - Check propertes of first (and only) item in nested table ok 54 - new: No more rows expected (nested table) ok 55 - new: Prepare select with nested object ok 56 - new: Execute (nested object) ok 57 - new: Fetch first row (nested object) ok 58 - Check obj.num ok 59 - Check obj.obj ok 60 - new: Fetch second row (nested object) ok 61 - Check obj.num ok 62 - Check obj.obj ok 63 - new: Fetch third row (nested object) ok 64 - Check obj ok 65 - new: No more rows expected (nested object) ok t/60reauth.t .................. skipped: ORACLE_USERID_2 not defined. t/70meta.t .................... 1..21 # type_info_all ok 1 - more than 8 types # $VAR1 = { # 'CREATE_PARAMS' => undef, # 'SQL_DATETIME_SUB' => undef, # 'CASE_SENSITIVE' => 0, # 'NUM_PREC_RADIX' => undef, # 'TYPE_NAME' => 'LONG RAW', # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_SUFFIX' => '\'', # 'LITERAL_PREFIX' => '\'', # 'LOCAL_TYPE_NAME' => 'LONG RAW', # 'MINIMUM_SCALE' => undef, # 'INTERVAL_PRECISION' => undef, # 'UNSIGNED_ATTRIBUTE' => undef, # 'AUTO_UNIQUE_VALUE' => undef, # 'SQL_DATA_TYPE' => -4, # 'COLUMN_SIZE' => 2147483647, # 'SEARCHABLE' => 0, # 'DATA_TYPE' => -4, # 'MAXIMUM_SCALE' => undef, # 'NULLABLE' => 1 # }; # $VAR2 = { # 'NUM_PREC_RADIX' => undef, # 'TYPE_NAME' => 'RAW', # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_SUFFIX' => '\'', # 'LITERAL_PREFIX' => '\'', # 'CREATE_PARAMS' => 'max length', # 'SQL_DATETIME_SUB' => undef, # 'CASE_SENSITIVE' => 0, # 'COLUMN_SIZE' => 2000, # 'SEARCHABLE' => 3, # 'DATA_TYPE' => -3, # 'MAXIMUM_SCALE' => undef, # 'NULLABLE' => 1, # 'LOCAL_TYPE_NAME' => 'RAW', # 'INTERVAL_PRECISION' => undef, # 'MINIMUM_SCALE' => undef, # 'UNSIGNED_ATTRIBUTE' => undef, # 'AUTO_UNIQUE_VALUE' => undef, # 'SQL_DATA_TYPE' => -3 # }; # $VAR3 = { # 'SQL_DATA_TYPE' => -1, # 'AUTO_UNIQUE_VALUE' => undef, # 'UNSIGNED_ATTRIBUTE' => undef, # 'INTERVAL_PRECISION' => undef, # 'MINIMUM_SCALE' => undef, # 'LOCAL_TYPE_NAME' => 'LONG', # 'NULLABLE' => 1, # 'MAXIMUM_SCALE' => undef, # 'DATA_TYPE' => -1, # 'SEARCHABLE' => 0, # 'COLUMN_SIZE' => 2147483647, # 'CASE_SENSITIVE' => 1, # 'SQL_DATETIME_SUB' => undef, # 'CREATE_PARAMS' => undef, # 'LITERAL_PREFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_SUFFIX' => '\'', # 'TYPE_NAME' => 'LONG', # 'NUM_PREC_RADIX' => undef # }; # $VAR4 = { # 'SQL_DATETIME_SUB' => undef, # 'CREATE_PARAMS' => 'max length', # 'CASE_SENSITIVE' => 1, # 'TYPE_NAME' => 'CHAR', # 'LITERAL_PREFIX' => '\'', # 'LITERAL_SUFFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'NUM_PREC_RADIX' => undef, # 'INTERVAL_PRECISION' => undef, # 'MINIMUM_SCALE' => undef, # 'SQL_DATA_TYPE' => 1, # 'AUTO_UNIQUE_VALUE' => 0, # 'UNSIGNED_ATTRIBUTE' => undef, # 'LOCAL_TYPE_NAME' => 'CHAR', # 'NULLABLE' => 1, # 'MAXIMUM_SCALE' => undef, # 'SEARCHABLE' => 3, # 'COLUMN_SIZE' => 2000, # 'DATA_TYPE' => 1 # }; # $VAR5 = { # 'LOCAL_TYPE_NAME' => 'DECIMAL', # 'MINIMUM_SCALE' => 0, # 'INTERVAL_PRECISION' => undef, # 'SQL_DATA_TYPE' => 3, # 'AUTO_UNIQUE_VALUE' => 0, # 'UNSIGNED_ATTRIBUTE' => 0, # 'COLUMN_SIZE' => 38, # 'SEARCHABLE' => 3, # 'DATA_TYPE' => 3, # 'MAXIMUM_SCALE' => 38, # 'NULLABLE' => 1, # 'CREATE_PARAMS' => 'precision,scale', # 'SQL_DATETIME_SUB' => undef, # 'CASE_SENSITIVE' => 0, # 'NUM_PREC_RADIX' => 10, # 'TYPE_NAME' => 'DECIMAL', # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_SUFFIX' => undef, # 'LITERAL_PREFIX' => undef # }; # $VAR6 = { # 'DATA_TYPE' => 8, # 'COLUMN_SIZE' => 15, # 'SEARCHABLE' => 3, # 'MAXIMUM_SCALE' => undef, # 'NULLABLE' => 1, # 'LOCAL_TYPE_NAME' => 'DOUBLE PRECISION', # 'AUTO_UNIQUE_VALUE' => 0, # 'SQL_DATA_TYPE' => 8, # 'UNSIGNED_ATTRIBUTE' => 0, # 'INTERVAL_PRECISION' => undef, # 'MINIMUM_SCALE' => undef, # 'NUM_PREC_RADIX' => 10, # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_SUFFIX' => undef, # 'LITERAL_PREFIX' => undef, # 'TYPE_NAME' => 'DOUBLE PRECISION', # 'CASE_SENSITIVE' => 0, # 'CREATE_PARAMS' => undef, # 'SQL_DATETIME_SUB' => undef # }; # $VAR7 = { # 'AUTO_UNIQUE_VALUE' => 0, # 'SQL_DATA_TYPE' => 9, # 'UNSIGNED_ATTRIBUTE' => undef, # 'INTERVAL_PRECISION' => undef, # 'MINIMUM_SCALE' => 0, # 'LOCAL_TYPE_NAME' => 'DATE', # 'NULLABLE' => 1, # 'MAXIMUM_SCALE' => 0, # 'DATA_TYPE' => 93, # 'SEARCHABLE' => 3, # 'COLUMN_SIZE' => 19, # 'CASE_SENSITIVE' => 0, # 'SQL_DATETIME_SUB' => 3, # 'CREATE_PARAMS' => undef, # 'LITERAL_PREFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_SUFFIX' => '\'', # 'TYPE_NAME' => 'DATE', # 'NUM_PREC_RADIX' => undef # }; # $VAR8 = { # 'DATA_TYPE' => 12, # 'COLUMN_SIZE' => '4000', # 'SEARCHABLE' => 3, # 'MAXIMUM_SCALE' => undef, # 'NULLABLE' => 1, # 'LOCAL_TYPE_NAME' => 'VARCHAR2', # 'SQL_DATA_TYPE' => 12, # 'AUTO_UNIQUE_VALUE' => 0, # 'UNSIGNED_ATTRIBUTE' => undef, # 'MINIMUM_SCALE' => undef, # 'INTERVAL_PRECISION' => undef, # 'NUM_PREC_RADIX' => undef, # 'LITERAL_SUFFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_PREFIX' => '\'', # 'TYPE_NAME' => 'VARCHAR2', # 'CASE_SENSITIVE' => 1, # 'CREATE_PARAMS' => 'max length', # 'SQL_DATETIME_SUB' => undef # }; # $VAR9 = { # 'LOCAL_TYPE_NAME' => 'BLOB', # 'MINIMUM_SCALE' => undef, # 'INTERVAL_PRECISION' => undef, # 'AUTO_UNIQUE_VALUE' => undef, # 'SQL_DATA_TYPE' => -4, # 'UNSIGNED_ATTRIBUTE' => undef, # 'SEARCHABLE' => 0, # 'COLUMN_SIZE' => 2147483647, # 'DATA_TYPE' => 30, # 'NULLABLE' => 1, # 'MAXIMUM_SCALE' => undef, # 'SQL_DATETIME_SUB' => undef, # 'CREATE_PARAMS' => undef, # 'CASE_SENSITIVE' => 1, # 'NUM_PREC_RADIX' => undef, # 'TYPE_NAME' => 'BLOB', # 'LITERAL_PREFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_SUFFIX' => '\'' # }; # $VAR10 = { # 'CASE_SENSITIVE' => 1, # 'CREATE_PARAMS' => undef, # 'SQL_DATETIME_SUB' => undef, # 'NUM_PREC_RADIX' => undef, # 'LITERAL_SUFFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_PREFIX' => '\'', # 'TYPE_NAME' => 'BFILE', # 'LOCAL_TYPE_NAME' => 'BFILE', # 'UNSIGNED_ATTRIBUTE' => undef, # 'AUTO_UNIQUE_VALUE' => undef, # 'SQL_DATA_TYPE' => -4, # 'INTERVAL_PRECISION' => undef, # 'MINIMUM_SCALE' => undef, # 'DATA_TYPE' => -9114, # 'COLUMN_SIZE' => 2147483647, # 'SEARCHABLE' => 0, # 'MAXIMUM_SCALE' => undef, # 'NULLABLE' => 1 # }; # $VAR11 = { # 'NUM_PREC_RADIX' => undef, # 'FIXED_PREC_SCALE' => 0, # 'LITERAL_SUFFIX' => '\'', # 'LITERAL_PREFIX' => '\'', # 'TYPE_NAME' => 'CLOB', # 'CASE_SENSITIVE' => 1, # 'CREATE_PARAMS' => undef, # 'SQL_DATETIME_SUB' => undef, # 'DATA_TYPE' => 40, # 'COLUMN_SIZE' => 2147483647, # 'SEARCHABLE' => 0, # 'MAXIMUM_SCALE' => undef, # 'NULLABLE' => 1, # 'LOCAL_TYPE_NAME' => 'CLOB', # 'AUTO_UNIQUE_VALUE' => undef, # 'UNSIGNED_ATTRIBUTE' => undef, # 'SQL_DATA_TYPE' => -1, # 'MINIMUM_SCALE' => undef, # 'INTERVAL_PRECISION' => undef # }; # $VAR12 = { # 'CASE_SENSITIVE' => 0, # 'SQL_DATETIME_SUB' => 5, # 'CREATE_PARAMS' => 'precision', # 'NUM_PREC_RADIX' => undef, # 'LITERAL_PREFIX' => 'TIMESTAMP\'', # 'LITERAL_SUFFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'TYPE_NAME' => 'TIMESTAMP WITH TIME ZONE', # 'LOCAL_TYPE_NAME' => undef, # 'AUTO_UNIQUE_VALUE' => 0, # 'UNSIGNED_ATTRIBUTE' => undef, # 'SQL_DATA_TYPE' => 11, # 'INTERVAL_PRECISION' => undef, # 'MINIMUM_SCALE' => 0, # 'DATA_TYPE' => 95, # 'SEARCHABLE' => 3, # 'COLUMN_SIZE' => 40, # 'NULLABLE' => 1, # 'MAXIMUM_SCALE' => 6 # }; # $VAR13 = { # 'CASE_SENSITIVE' => 0, # 'SQL_DATETIME_SUB' => 10, # 'CREATE_PARAMS' => 'precision', # 'LITERAL_PREFIX' => 'INTERVAL\'', # 'LITERAL_SUFFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'TYPE_NAME' => 'INTERVAL DAY TO SECOND', # 'NUM_PREC_RADIX' => undef, # 'SQL_DATA_TYPE' => 10, # 'AUTO_UNIQUE_VALUE' => 0, # 'UNSIGNED_ATTRIBUTE' => undef, # 'MINIMUM_SCALE' => 0, # 'INTERVAL_PRECISION' => undef, # 'LOCAL_TYPE_NAME' => undef, # 'NULLABLE' => 1, # 'MAXIMUM_SCALE' => 9, # 'DATA_TYPE' => 110, # 'SEARCHABLE' => 3, # 'COLUMN_SIZE' => 22 # }; # $VAR14 = { # 'LOCAL_TYPE_NAME' => undef, # 'AUTO_UNIQUE_VALUE' => 0, # 'UNSIGNED_ATTRIBUTE' => undef, # 'SQL_DATA_TYPE' => 10, # 'MINIMUM_SCALE' => 0, # 'INTERVAL_PRECISION' => undef, # 'DATA_TYPE' => 107, # 'SEARCHABLE' => 3, # 'COLUMN_SIZE' => 13, # 'NULLABLE' => 1, # 'MAXIMUM_SCALE' => 9, # 'CASE_SENSITIVE' => 0, # 'SQL_DATETIME_SUB' => 7, # 'CREATE_PARAMS' => 'precision', # 'NUM_PREC_RADIX' => undef, # 'LITERAL_PREFIX' => 'INTERVAL\'', # 'LITERAL_SUFFIX' => '\'', # 'FIXED_PREC_SCALE' => 0, # 'TYPE_NAME' => 'INTERVAL YEAR TO MONTH' # }; # tables(): # 7540 tables ok 2 - tables # schema list: table_info(undef, '%', undef, undef) ok 3 - table_info ok 4 - table_info fetch ok 5 - table_info data returned # schema list: 14 rows, 0 seconds # type list: table_info(undef, undef, undef, '%') ok 6 - table_info ok 7 - table_info fetch ok 8 - table_info data returned # type list: 4 rows, 0 seconds # table list: table_info(undef, undef, undef, undef) ok 9 - table_info ok 10 - table_info fetch ok 11 - table_info data returned # table list: 7540 rows, 0 seconds ok 12 - dbms_version # sql_dbms_version=11.02.0000 ok 13 - matched ok 14 - LongReadLen is at default ok 15 - column_info sth ok 16 - LongReadLen still at default ok 17 - sth->fetchrow_hashref lived ok 18 - long DEFAULT matched ok 19 - sth->finish ok 20 - LongReadLen still at default ok 21 - drop table ok t/80ora_charset.t ............. # set $ENV{NLS_LANG='AMERICAN_AMERICA.AL32UTF8' 1..14 # row: 1: nice_string=° byte_string=176 (°, '°') # create table dbd_ora__drop_mecpanfly52264 ( idx integer, ch varchar2(20), nch nvarchar2(20), descr varchar2(50), dt date ) ok 1 - prepared: insert into dbd_ora__drop_mecpanfly52264 ( idx, ch, nch, descr, dt ) values( ?, ?, ?, ?, sysdate ) ok 2 - bind_param idx ok 3 - bind_param ch withOUT attribute ora_csform ok 4 - bind_param nch ok 5 - bind_param descr withOUT attribute ora_csform ok 6 - insert row 1: DEGREE SIGN ok 7 ok 8 ok 9 - match char ok 10 - match char # set $ENV{NLS_LANG='AMERICAN_AMERICA.WE8ISO8859P1' ok 11 ok 12 ok 13 - match char ok 14 - match char ok t/rt13865.t ................... 1..9 ok 1 - INTEGER is alias for NUMBER(38) ok 2 - NUMBER(37) ok 3 - NUMBER ok 4 - VARCHAR(67) ok 5 - VARCHAR(69) ok 6 - NVARCHAR2(69) ok 7 - NCHAR(69) ok 8 - CHAR(67) ok 9 - CHAR(69) ok t/rt74753-utf8-encoded.t ...... 1..3 ok 1 - utf8 encoded ok 2 - utf8 encoded ok 3 - truncated, yet utf8 encoded ok t/rt85886.t ................... 1..2 ok 1 - correct value returned ok 2 - ivok ok All tests successful. Test Summary Report ------------------- t/31lob.t (Wstat: 0 Tests: 12 Failed: 0) TODO passed: 9-11 Files=38, Tests=1861, 70 wallclock secs ( 0.67 usr + 0.14 sys = 0.81 CPU) Result: PASS PYTHIAN/DBD-Oracle-1.74.tar.gz dmake test TEST_VERBOSE=1 -- OK Fetching with LWP: http://ppm.activestate.com/CPAN/authors/id/P/PY/PYTHIAN/CHECKSUMS Pythian Remote DBA <pause-at-pythian.com> Oracle database driver for the DBI module >>> (cd C:\cpanfly-5.22-64\var\cpan\build\DBD-Oracle-1.74-1OMOOz && tar cvf - DBD-Oracle-1.74.ppd blib) | gzip -c >C:/cpanfly-5.22-64/var/REPO/P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz DBD-Oracle-1.74.ppd blib/ blib/arch/ blib/arch/auto/ blib/arch/auto/DBD/ blib/arch/auto/DBD/Oracle/ blib/arch/auto/DBD/Oracle/dbdimp.h blib/arch/auto/DBD/Oracle/mk.pm blib/arch/auto/DBD/Oracle/ocitrace.h blib/arch/auto/DBD/Oracle/Oracle.dll blib/arch/auto/DBD/Oracle/Oracle.h blib/lib/ blib/lib/DBD/ blib/lib/DBD/Oracle/ blib/lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Troubleshooting/ blib/lib/DBD/Oracle/Troubleshooting/Aix.pod blib/lib/DBD/Oracle/Troubleshooting/Cygwin.pod blib/lib/DBD/Oracle/Troubleshooting/Hpux.pod blib/lib/DBD/Oracle/Troubleshooting/Linux.pod blib/lib/DBD/Oracle/Troubleshooting/Macos.pod blib/lib/DBD/Oracle/Troubleshooting/Sun.pod blib/lib/DBD/Oracle/Troubleshooting/Vms.pod blib/lib/DBD/Oracle/Troubleshooting/Win32.pod blib/lib/DBD/Oracle/Troubleshooting/Win64.pod blib/lib/DBD/Oracle/Troubleshooting.pod blib/lib/DBD/Oracle.pm >>> mv C:\cpanfly-5.22-64\var\cpan\build\DBD-Oracle-1.74-1OMOOz/DBD-Oracle-1.74.ppd C:/cpanfly-5.22-64/var/REPO/P/PY/PYTHIAN Finished 2016-01-14T06:01:48