DBI 1.622-ithread default trace level set to 0x0/6 (pid 19207 pi 77d010) at DBI.pm line 276 via DBI.pm line 0 -> DBI->connect(dbi:Oracle:, *****/*****, ****, HASH(0x780c18)) -> DBI->install_driver(Oracle) for linux perl=5.016000 pid=19207 ruid=9083 euid=9083 install_driver: DBD::Oracle version 1.52 loaded from /tmp/dbd/DBD-Oracle-1.52/blib/lib/DBD/Oracle.pm New 'DBI::dr' (for DBD::Oracle::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0xc63c60)=>DBI::dr=HASH(0xc63be8), DBD::Oracle::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::Oracle::dr, 192, 0) thr#77d010 dbih_setup_attrib(DBI::dr=HASH(0xc63be8), Err, Null!) SCALAR(0x9bc700) (already defined) dbih_setup_attrib(DBI::dr=HASH(0xc63be8), State, Null!) SCALAR(0xa325b8) (already defined) dbih_setup_attrib(DBI::dr=HASH(0xc63be8), Errstr, Null!) SCALAR(0x9bc670) (already defined) dbih_setup_attrib(DBI::dr=HASH(0xc63be8), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0xc63be8), FetchHashKeyName, Null!) 'NAME' (already defined) -> STORE in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0xc63c60)~0xc63be8 'ShowErrorStatement' 1) thr#77d010 STORE DBI::dr=HASH(0xc63be8) 'ShowErrorStatement' => 1 <- STORE= ( 1 ) [1 items] at /tmp/dbd/DBD-Oracle-1.52/blib/lib/DBD/Oracle.pm line 80 <- install_driver= DBI::dr=HASH(0xc63c60) -> connect for DBD::Oracle::dr (DBI::dr=HASH(0xc63c60)~0xc63be8 '' '*****/*****' **** HASH(0x9ceeb0)) thr#77d010 New 'DBI::db' (for DBD::Oracle::db, parent=DBI::dr=HASH(0xc63be8), id=undef) dbih_setup_handle(DBI::db=HASH(0xc5df58)=>DBI::db=HASH(0xc5e078), DBD::Oracle::db, a329c0, Null!) dbih_make_com(DBI::dr=HASH(0xc63be8), c5f3d0, DBD::Oracle::db, 408, c5e048) thr#77d010 dbih_setup_attrib(DBI::db=HASH(0xc5e078), Err, DBI::dr=HASH(0xc63be8)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::db=HASH(0xc5e078), State, DBI::dr=HASH(0xc63be8)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::db=HASH(0xc5e078), Errstr, DBI::dr=HASH(0xc63be8)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::db=HASH(0xc5e078), TraceLevel, DBI::dr=HASH(0xc63be8)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0xc5e078), FetchHashKeyName, DBI::dr=HASH(0xc63be8)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0xc5e078), HandleSetErr, DBI::dr=HASH(0xc63be8)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0xc5e078), HandleError, DBI::dr=HASH(0xc63be8)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0xc5e078), ReadOnly, DBI::dr=HASH(0xc63be8)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0xc5e078), Profile, DBI::dr=HASH(0xc63be8)) undef (not defined) OCIAttrSet(0,OCI_HTYPE_SESSION, 7ffff672ca8f,11,Attr=OCI_ATTR_DRIVER_NAME,0)=INVALID_HANDLE Environment variables: PERL_DL_NONLAZY=1 DBI_TRACE=6 nolinks= TERM=xterm SHELL=/usr/local/bin/bash history_control=ignoredups OLDPWD=/tmp/dbd SSH_TTY=/dev/pts/0 TWO_TASK=**** ORA_NLS11=/software/oracle-ic-11.2/nls/data LD_LIBRARY_PATH=/software/oracle-ic-11.2 notify= DONEFUNCS=yes PAGER=less ORACLE_USERID=*****/***** TNS_ADMIN=/etc PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/software/bin:/software/oracle-ic-11.2 command_oriented_history= PWD=/tmp/dbd/DBD-Oracle-1.52 no_exit_on_falied_exec= LANG=en_GB.UTF-8 ignoreeof=1 PS3=bash3> PS2=bash2> SHLVL=1 PS4=bash4> ARCH=Linux ORACLE_HOME=/software/oracle-ic-11.2 _=/software/bin/perl-5.16.0 HARNESS_ACTIVE=1 HARNESS_VERSION=3.25 HARNESS_IS_VERBOSE=1 TAP_VERSION=13 PERL5LIB=/tmp/dbd/DBD-Oracle-1.52/blib/lib:/tmp/dbd/DBD-Oracle-1.52/blib/arch OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS OCIEnvNlsEnvCreate(c04048,OBJECT,2,0,0,0,0,0,0,1,1)=SUCCESS OCIHandleAlloc(dccfe0,c04050,OCI_HTYPE_ERROR,0,0)=SUCCESS OCIAttrGet(dccfe0,OCI_HTYPE_ENV,7ffff6937880,0,31,e09aa8)=SUCCESS OCIAttrGet(dccfe0,OCI_HTYPE_ENV,7ffff6937882,0,262,e09aa8)=SUCCESS charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII (csid: utf8=871 al32utf8=873) OCIHandleAlloc(dccfe0,c04058,OCI_HTYPE_SERVER,0,0)=SUCCESS OCIHandleAlloc(dccfe0,c04060,OCI_HTYPE_SVCCTX,0,0)=SUCCESS OCIServerAttach(e0a160, e09aa8, "", 0, mode=DEFAULT,0)=SUCCESS OCIAttrSet(e099c8,OCI_HTYPE_SVCCTX, e0a160,0,Attr=OCI_ATTR_SERVER,e09aa8)=SUCCESS OCIHandleAlloc(dccfe0,c04068,OCI_HTYPE_SESSION,0,0)=SUCCESS OCIAttrSet(e6f7b0,OCI_HTYPE_SESSION, e15a20,12,Attr=OCI_ATTR_USERNAME,e09aa8)=SUCCESS OCIAttrSet(e6f7b0,OCI_HTYPE_SESSION, e15a2d,12,Attr=OCI_ATTR_PASSWORD,e09aa8)=SUCCESS OCISessionBegin(e099c8,e09aa8,e6f7b0,1,mode=DEFAULT 0)=SUCCESS OCIAttrSet(e099c8,OCI_HTYPE_SVCCTX, e6f7b0,0,Attr=OCI_ATTR_SESSION,e09aa8)=SUCCESS <- connect= ( DBI::db=HASH(0xc5df58) ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 658 -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'PrintError' 0) thr#77d010 STORE DBI::db=HASH(0xc5e078) 'PrintError' => 0 <- STORE= ( 1 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 710 -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'AutoCommit' 1) thr#77d010 <- STORE= ( 1 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 710 -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'Username' '*****/*****') thr#77d010 STORE DBI::db=HASH(0xc5e078) 'Username' => '*****/*****' <- STORE= ( 1 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 713 via at t/31lob.t line 14 -> connected in DBD::_::db for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'dbi:Oracle:' '*****/*****' **** HASH(0x780c18)) thr#77d010 <- connected= ( undef ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 720 <- connect= DBI::db=HASH(0xc5df58) -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'dbi_connect_closure' CODE(0xc63510)) thr#77d010 STORE DBI::db=HASH(0xc5e078) 'dbi_connect_closure' => CODE(0xc63510) <- STORE= ( 1 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 729 via at t/31lob.t line 14 -> FETCH for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'PrintError') thr#77d010 .. FETCH DBI::db=HASH(0xc5e078) 'PrintError' = '' <- FETCH= ( '' ) [1 items] at t/nchar_test_lib.pl line 202 via at t/31lob.t line 20 -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'PrintError' 0) thr#77d010 STORE DBI::db=HASH(0xc5e078) 'PrintError' => 0 <- STORE= ( 1 ) [1 items] at t/nchar_test_lib.pl line 202 via at t/31lob.t line 20 -> FETCH for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'Active') thr#77d010 .. FETCH DBI::db=HASH(0xc5e078) 'Active' = 1 <- FETCH= ( 1 ) [1 items] at t/nchar_test_lib.pl line 203 via at t/31lob.t line 20 -> do in DBD::_::db for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 ' drop table dbd_ora__drop_me ') thr#77d010 1 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER ' drop table dbd_ora__drop_me ' undef) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5daa8)=>DBI::st=HASH(0xc5df40), DBD::Oracle::st, a32e28, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5df40), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5df40), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5df40), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5df40), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5df40), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5df40), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5df40), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5df40), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5df40), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) OCIHandleAlloc(dccfe0,e84738,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e4c3d8,e09aa8,' drop table dbd_ora__drop_me ',29,1,0)=SUCCESS OCIAttrGet(e4c3d8,OCI_HTYPE_STMT,e8474c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql DROP ( auto_lob1, check_sql1) dbd_describe skipped for DROP 1 <- prepare= ( DBI::st=HASH(0xc5daa8) ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1611 via at t/nchar_test_lib.pl line 203 -> execute for DBD::Oracle::st (DBI::st=HASH(0xc5daa8)~0xc5df40) thr#77d010 dbd_st_execute DROP (out0, lob0)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(e099c8,e4c3d8,e09aa8,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=ERROR OCIAttrGet(e4c3d8,OCI_HTYPE_STMT,7fffffffdd7e,0,OCI_ATTR_PARSE_ERROR_OFFSET,e09aa8)=SUCCESS OCIErrorGet(e09aa8,1,"",7fffffffd97c,"ORA-00942: table or view does not exist ",1024,2)=SUCCESS OCIErrorGet after error possibly near <*> indicator at char 12 in ' drop table <*>dbd_ora__drop_me ' (er1:ok): -1, 942: ORA-00942: table or view does not exist OCIErrorGet(e09aa8,2,"",7fffffffd97c,"ORA-00942: table or view does not exist ",1024,2)=NO_DATA !! ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in ' drop table <*>dbd_ora__drop_me ')' (err#1) <- execute= ( undef ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1612 via at t/nchar_test_lib.pl line 203 <> DESTROY(DBI::st=HASH(0xc5daa8)) ignored for outer handle (inner DBI::st=HASH(0xc5df40) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5df40)~INNER) thr#77d010 dbd_st_destroy OCIHandleFree(e4c3d8,OCI_HTYPE_STMT)=SUCCESS ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in ' drop table <*>dbd_ora__drop_me ')' (err#1) <- DESTROY= ( undef ) [1 items] at t/nchar_test_lib.pl line 203 via at t/nchar_test_lib.pl line 203 DESTROY (dbih_clearcom) (sth 0xc5df40, com 0xe84650, imp DBD::Oracle::st): FLAGS 0x182011: COMSET Warn PrintWarn ShowErrorStatement ERR 942 ERRSTR 'ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in ' drop table <*>dbd_ora__drop_me ')' PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) NUM_OF_FIELDS -1 NUM_OF_PARAMS 0 dbih_clearcom 0xc5df40 (com 0xe84650, type 3) done. !! ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in ' drop table <*>dbd_ora__drop_me ')' (err#0) <- do= ( undef ) [1 items] at t/nchar_test_lib.pl line 203 via at t/31lob.t line 20 1 -> FETCH for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'ParamValues') thr#77d010 .. FETCH DBI::db=HASH(0xc5e078) 'ParamValues' = undef ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in ' drop table <*>dbd_ora__drop_me ')' (err#0) 1 <- FETCH= ( undef ) [1 items] at t/nchar_test_lib.pl line 203 via at t/31lob.t line 20 -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'PrintError' '') thr#77d010 STORE DBI::db=HASH(0xc5e078) 'PrintError' => '' ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in ' drop table <*>dbd_ora__drop_me ')' (err#0) <- STORE= ( 1 ) [1 items] at t/31lob.t line 20 via at t/31lob.t line 20 !! ERROR: 942 CLEARED by call to do method -> do in DBD::_::db for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 ' CREATE TABLE dbd_ora__drop_me ( id INTEGER NOT NULL, data BLOB ) ') thr#77d010 1 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER ' CREATE TABLE dbd_ora__drop_me ( id INTEGER NOT NULL, data BLOB ) ' undef) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5dc88)=>DBI::st=HASH(0xc5dd60), DBD::Oracle::st, c5d6a0, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5dd60), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd60), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd60), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd60), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd60), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd60), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd60), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd60), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd60), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) OCIHandleAlloc(dccfe0,e84538,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e4b348,e09aa8,' CREATE TABLE dbd_ora__drop_me ( id INTEGER NOT NULL, data BLOB ) ',77,1,0)=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,e8454c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql CREATE ( auto_lob1, check_sql1) dbd_describe skipped for CREATE 1 <- prepare= ( DBI::st=HASH(0xc5dc88) ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1611 via at t/31lob.t line 22 -> execute for DBD::Oracle::st (DBI::st=HASH(0xc5dc88)~0xc5dd60) thr#77d010 dbd_st_execute CREATE (out0, lob0)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(e099c8,e4b348,e09aa8,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,7fffffffdeb8,0,OCI_ATTR_ROW_COUNT,e09aa8)=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,7fffffffdebe,0,OCI_ATTR_SQLFNCODE,e09aa8)=SUCCESS dbd_st_execute CREATE returned (SUCCESS, rpc0, fn1, out0) <- execute= ( '0E0' ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1612 via at t/31lob.t line 22 -> rows for DBD::Oracle::st (DBI::st=HASH(0xc5dc88)~0xc5dd60) thr#77d010 OCIAttrGet(e4b348,OCI_HTYPE_STMT,7fffffffdedc,0,OCI_ATTR_ROW_COUNT,e09aa8)=SUCCESS <- rows= ( 0 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1613 via at t/31lob.t line 22 <> DESTROY(DBI::st=HASH(0xc5dc88)) ignored for outer handle (inner DBI::st=HASH(0xc5dd60) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5dd60)~INNER) thr#77d010 dbd_st_destroy OCIHandleFree(e4b348,OCI_HTYPE_STMT)=SUCCESS <- DESTROY= ( undef ) [1 items] at t/31lob.t line 22 via at t/31lob.t line 22 DESTROY (dbih_clearcom) (sth 0xc5dd60, com 0xe84450, imp DBD::Oracle::st): FLAGS 0x182011: COMSET Warn PrintWarn ShowErrorStatement PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) NUM_OF_FIELDS -1 NUM_OF_PARAMS 0 dbih_clearcom 0xc5dd60 (com 0xe84450, type 3) done. <- do= ( '0E0' ) [1 items] at t/31lob.t line 22 -> do in DBD::_::db for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'INSERT INTO dbd_ora__drop_me (id,data) VALUES (1, EMPTY_BLOB())') thr#77d010 1 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'INSERT INTO dbd_ora__drop_me (id,data) VALUES (1, EMPTY_BLOB())' undef) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5daa8)=>DBI::st=HASH(0xc5dc88), DBD::Oracle::st, c5d820, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5dc88), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dc88), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dc88), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dc88), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dc88), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dc88), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dc88), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dc88), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dc88), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) OCIHandleAlloc(dccfe0,e84508,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e4b348,e09aa8,'INSERT INTO dbd_ora__drop_me (id,data) VALUES (1, EMPTY_BLOB())',63,1,0)=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,e8451c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql INSERT ( auto_lob1, check_sql1) dbd_describe skipped for INSERT 1 <- prepare= ( DBI::st=HASH(0xc5daa8) ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1611 via at t/31lob.t line 32 -> execute for DBD::Oracle::st (DBI::st=HASH(0xc5daa8)~0xc5dc88) thr#77d010 dbd_st_execute INSERT (out0, lob0)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(e099c8,e4b348,e09aa8,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,7fffffffdeb8,0,OCI_ATTR_ROW_COUNT,e09aa8)=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,7fffffffdebe,0,OCI_ATTR_SQLFNCODE,e09aa8)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) <- execute= ( 1 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1612 via at t/31lob.t line 32 -> rows for DBD::Oracle::st (DBI::st=HASH(0xc5daa8)~0xc5dc88) thr#77d010 OCIAttrGet(e4b348,OCI_HTYPE_STMT,7fffffffdedc,0,OCI_ATTR_ROW_COUNT,e09aa8)=SUCCESS <- rows= ( 1 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1613 via at t/31lob.t line 32 <> DESTROY(DBI::st=HASH(0xc5daa8)) ignored for outer handle (inner DBI::st=HASH(0xc5dc88) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5dc88)~INNER) thr#77d010 dbd_st_destroy OCIHandleFree(e4b348,OCI_HTYPE_STMT)=SUCCESS <- DESTROY= ( undef ) [1 items] at t/31lob.t line 32 via at t/31lob.t line 32 DESTROY (dbih_clearcom) (sth 0xc5dc88, com 0xe84420, imp DBD::Oracle::st): FLAGS 0x182011: COMSET Warn PrintWarn ShowErrorStatement PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) NUM_OF_FIELDS -1 NUM_OF_PARAMS 0 dbih_clearcom 0xc5dc88 (com 0xe84420, type 3) done. <- do= ( 1 ) [1 items] at t/31lob.t line 32 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'SELECT data FROM dbd_ora__drop_me WHERE id = ?' HASH(0xc5dd30)) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5df40)=>DBI::st=HASH(0xc5de08), DBD::Oracle::st, c5d808, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5de08), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) dbd_preparse scanned 1 distinct placeholders OCIHandleAlloc(dccfe0,e85b88,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e4b348,e09aa8,'SELECT data FROM dbd_ora__drop_me WHERE id = :p1',48,1,0)=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,e85b9c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql SELECT ( auto_lob0, check_sql1) dbd_describe SELECT (EXPLICIT, lb 80)... OCIStmtExecute(e099c8,e4b348,e09aa8,0,0,0,0,mode=DESCRIBE_ONLY,16)=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,7fffffffe01c,0,OCI_ATTR_PARAM_COUNT,e09aa8)=SUCCESS OCIParamGet(e4b348,4,e09aa8,e84070,1,OCI_HTYPE_STMT)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840a0,0,OCI_ATTR_DATA_TYPE,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840a2,0,OCI_ATTR_DATA_SIZE,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840b8,0,OCI_ATTR_CHAR_USED,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840ba,0,OCI_ATTR_CHAR_SIZE,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840bc,0,OCI_ATTR_CHARSET_ID,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840be,0,OCI_ATTR_CHARSET_FORM,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840a4,0,OCI_ATTR_PRECISION,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840a6,0,OCI_ATTR_SCALE,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840a7,0,OCI_ATTR_IS_NULL,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e840a8,7fffffffe018,OCI_ATTR_NAME,e09aa8)=SUCCESS Describe col #1 type=113(SQLT_BLOB / long) OCIDescriptorAlloc(dccfe0,e84080,OCI_DTYPE_LOB,0,0) Described col 1: dbtype 113(SQLT_BLOB / long), scale 0, prec 0, nullok 1, name DATA : dbsize 4000, char_used 0, char_size 0, csid 0, csform 0(0), disize 8 fbh 1: 'DATA' NULLable, otype 113->113, dbsize 4000/8, p0.s0 OCIAttrSet(e4b348,OCI_HTYPE_STMT, 7fffffffe018,4,Attr=OCI_ATTR_PREFETCH_MEMORY,e09aa8)=SUCCESS OCIAttrSet(e4b348,OCI_HTYPE_STMT, 7fffffffe014,4,Attr=OCI_ATTR_PREFETCH_ROWS,e09aa8)=SUCCESS cache settings DB Handle RowCacheSize=0,Statement Handle RowCacheSize=0, OCI_ATTR_PREFETCH_ROWS=1, OCI_ATTR_PREFETCH_MEMORY=0, Rows per Fetch=1, Multiple Row Fetch=Off OCIDefineByPos(e4b348,e84078,e09aa8,1,e84080,0,113,e7fee0,e7fc90,e686d0,mode=DEFAULT,0)=SUCCESS dbd_describe'd 1 columns (row bytes: 4000 max, 4000 est avg, cache: 0) <- prepare= ( DBI::st=HASH(0xc5df40) ) [1 items] at t/31lob.t line 35 -> bind_param for DBD::Oracle::st (DBI::st=HASH(0xc5df40)~0xc5de08 1 1) thr#77d010 dbd_bind_ph(1): bind :p1 <== 1 (type 0 (DEFAULT (varchar))) dbd_rebind_ph() (1): rebinding :p1 as NULL (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 0) dbd_rebind_ph_char() (1): bind :p1 <== 1 (size 1/16/0, ptype 5(VARCHAR), otype 1 ) dbd_rebind_ph_char() (2): bind :p1 <== 1 (size 1/16, otype 1(VARCHAR), indp 0, at_exec 1) bind :p1 as ftype 1 (VARCHAR) OCIBindByName(e4b348,e86298,e09aa8,":p1",placeh_len=3,value_p=e85400,value_sz=16,dty=1,indp=e862b8,alenp=0,rcodep=e862b0,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS OCIBindDynamic(e4c808,e09aa8,e86260,7ffff671d590,e86260,7ffff671d830)=SUCCESS OCIAttrGet(e4c808,OCI_HTYPE_BIND,e8627c,0,31,e09aa8)=SUCCESS dbd_rebind_ph(): bind :p1 <== 1 (in, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 16, maxdata_size 0) OCIAttrSet(e4c808,OCI_HTYPE_BIND, 7fffffffe29c,0,Attr=31,e09aa8)=SUCCESS <- bind_param= ( 1 ) [1 items] at t/31lob.t line 37 -> execute for DBD::Oracle::st (DBI::st=HASH(0xc5df40)~0xc5de08) thr#77d010 dbd_st_execute SELECT (out0, lob0)... Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(e099c8,e4b348,e09aa8,0,0,0,0,mode=DEFAULT,0)=SUCCESS rs_array_init:imp_sth->rs_array_size=1, rs_array_idx=0, prefetch_rows=0, rs_array_status=SUCCESS OCIAttrGet(e4b348,OCI_HTYPE_STMT,7fffffffe37e,0,OCI_ATTR_SQLFNCODE,e09aa8)=SUCCESS dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0) <- execute= ( '0E0' ) [1 items] at t/31lob.t line 38 -> fetchrow for DBD::Oracle::st (DBI::st=HASH(0xc5df40)~0xc5de08) thr#77d010 dbd_st_fetch 1 fields... OCIStmtFetch(e4b348,e09aa8,1,2,0)=SUCCESS dbih_setup_fbav alloc for 1 fields dbih_setup_fbav now 1 fields dbd_st_fetched 1 fields with status of 0(SUCCESS) field #1 with rc=0(OK) c5daa8 (field=0): OCILobLocatorPtr=SCALAR(0xc5dbb0) <- fetchrow= ( OCILobLocatorPtr=SCALAR(0xc5dbb0) ) [1 items] row1 at t/31lob.t line 39 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'INSERT INTO dbd_ora__drop_me (id,data) VALUES (666, ?)') thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xa32ee8)=>DBI::st=HASH(0xc5dd00), DBD::Oracle::st, c5d7a8, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5dd00), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd00), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd00), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd00), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd00), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd00), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd00), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd00), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5dd00), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) dbd_preparse scanned 1 distinct placeholders OCIHandleAlloc(dccfe0,e84608,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e4ac70,e09aa8,'INSERT INTO dbd_ora__drop_me (id,data) VALUES (666, :p1)',56,1,0)=SUCCESS OCIAttrGet(e4ac70,OCI_HTYPE_STMT,e8461c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql INSERT ( auto_lob1, check_sql1) dbd_describe skipped for INSERT <- prepare= ( DBI::st=HASH(0xa32ee8) ) [1 items] at t/31lob.t line 45 <> DESTROY(DBI::st=HASH(0xc5df40)) ignored for outer handle (inner DBI::st=HASH(0xc5de08) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5de08)~INNER) thr#77d010 dbd_st_finish OCIStmtFetch(e4b348,e09aa8,0,2,0)=SUCCESS dbd_st_destroy OCIHandleFree(e4b348,OCI_HTYPE_STMT)=SUCCESS OCIOCILobFileIsOpen_log_stat(e099c8,e09aa8,e07558,7fffffffdf7c,0)=INVALID_HANDLE OCIDescriptorFree(e07558,OCI_DTYPE_LOB) <- DESTROY= ( undef ) [1 items] at t/31lob.t line 46 via at t/31lob.t line 46 DESTROY (dbih_clearcom) (sth 0xc5de08, com 0xe85aa0, imp DBD::Oracle::st): FLAGS 0x182011: COMSET Warn PrintWarn ShowErrorStatement PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) NUM_OF_FIELDS 1 NUM_OF_PARAMS 1 dbih_clearcom 0xc5de08 (com 0xe85aa0, type 3) done. -> bind_param for DBD::Oracle::st (DBI::st=HASH(0xa32ee8)~0xc5dd00 1 ' !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$...' HASH(0xb54748)) thr#77d010 dbd_bind_ph(1): bind :p1 <== ' !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$...' (type 0 (DEFAULT (varchar)), attribs: HASH(0xb54748)) dbd_rebind_ph() (1): rebinding :p1 as ' !"#$...' (not-utf8, ftype 113 (SQLT_BLOB / long), csid 0, csform 0(0), inout 0) OCIDescriptorAlloc(dccfe0,e8bb30,OCI_DTYPE_LOB,0,0) OCIAttrSet(e07558,OCI_DTYPE_LOB, 7fffffffe178,0,Attr=OCI_ATTR_LOBEMPTY,e09aa8)=SUCCESS bind :p1 as ftype 113 (SQLT_BLOB / long) OCIBindByName(e4ac70,e8bb28,e09aa8,":p1",placeh_len=3,value_p=e8bb30,value_sz=8,dty=113,indp=e8bb48,alenp=0,rcodep=e8bb40,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS OCIAttrGet(e49790,OCI_HTYPE_BIND,e8bb0c,0,31,e09aa8)=SUCCESS dbd_rebind_ph(): bind :p1 <== ' !"#$...' (in, not-utf8, csid 0->0->0, ftype 113 (SQLT_BLOB / long), csform 0(0)->0(0), maxlen 8, maxdata_size 0) <- bind_param= ( 1 ) [1 items] at t/31lob.t line 47 -> execute for DBD::Oracle::st (DBI::st=HASH(0xa32ee8)~0xc5dd00 ' !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$...') thr#77d010 dbd_bind_ph(1): bind :p1 <== ' !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$...' (type 0 (DEFAULT (varchar))) dbd_rebind_ph() (1): rebinding :p1 as ' !"#$...' (not-utf8, ftype 113 (SQLT_BLOB / long), csid 0, csform 0(0), inout 0) OCILobIsTemporary(dccfe0,e09aa8,e07558,7fffffffe01c)=SUCCESS OCIAttrSet(e07558,OCI_DTYPE_LOB, 7fffffffe0c8,0,Attr=OCI_ATTR_LOBEMPTY,e09aa8)=SUCCESS bind :p1 as ftype 113 (SQLT_BLOB / long) OCIBindByName(e4ac70,e8bb28,e09aa8,":p1",placeh_len=3,value_p=e8bb30,value_sz=8,dty=113,indp=e8bb48,alenp=0,rcodep=e8bb40,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS OCIAttrGet(e49790,OCI_HTYPE_BIND,e8bb0c,0,31,e09aa8)=SUCCESS dbd_rebind_ph(): bind :p1 <== ' !"#$...' (in, not-utf8, csid 0->0->0, ftype 113 (SQLT_BLOB / long), csform 0(0)->0(0), maxlen 8, maxdata_size 0) dbd_st_execute INSERT (out0, lob1)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(e099c8,e4ac70,e09aa8,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(e4ac70,OCI_HTYPE_STMT,7fffffffe378,0,OCI_ATTR_ROW_COUNT,e09aa8)=SUCCESS OCIAttrGet(e4ac70,OCI_HTYPE_STMT,7fffffffe37e,0,OCI_ATTR_SQLFNCODE,e09aa8)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) OCIHandleAlloc(dccfe0,e84610,OCI_HTYPE_DESCRIBE,0,0)=SUCCESS OCIDescribeAny(e099c8,e09aa8,e84e60,16,1,1,7,e4b7d0)=ERROR OCIDescribeAny(e099c8,e09aa8,e84e60,16,1,1,1,e4b7d0)=SUCCESS OCIAttrGet(e4b7d0,OCI_HTYPE_DESCRIBE,7fffffffe060,0,OCI_ATTR_PARAM,e09aa8)=SUCCESS OCIAttrGet(e4ca60,OCI_DTYPE_PARAM,7fffffffe07e,0,OCI_ATTR_NUM_COLS,e09aa8)=SUCCESS OCIAttrGet(e4ca60,OCI_DTYPE_PARAM,7fffffffe058,0,OCI_ATTR_LIST_COLUMNS,e09aa8)=SUCCESS lob refetch from table dbd_ora__drop_me, 2 columns: OCIParamGet(e4ca10,53,e09aa8,7fffffffe050,1,OCI_DTYPE_PARAM)=SUCCESS OCIAttrGet(e4c9c0,OCI_DTYPE_PARAM,7fffffffe070,0,OCI_ATTR_OBJECT,e09aa8)=SUCCESS OCIAttrGet(e4c9c0,OCI_DTYPE_PARAM,7fffffffe030,7fffffffe06c,OCI_ATTR_SQLCODE,e09aa8)=SUCCESS lob refetch table col 1: 'ID' otype 2 OCIParamGet(e4ca10,53,e09aa8,7fffffffe050,2,OCI_DTYPE_PARAM)=SUCCESS OCIAttrGet(e4c970,OCI_DTYPE_PARAM,7fffffffe070,0,OCI_ATTR_OBJECT,e09aa8)=SUCCESS OCIAttrGet(e4c970,OCI_DTYPE_PARAM,7fffffffe030,7fffffffe06c,OCI_ATTR_SQLCODE,e09aa8)=SUCCESS lob refetch table col 2: 'DATA' otype 113 OCIDescriptorFree(e4c970,OCI_DTYPE_PARAM) lob refetch :p1 param: otype 113, matched field 'DATA' by name (DATA "p1") OCIDescriptorAlloc(dccfe0,e84d60,OCI_DTYPE_LOB,0,0) lob refetch sql: select DATA "p1" from dbd_ora__drop_me where rowid = :rid for update OCIHandleAlloc(dccfe0,e84060,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e48228,e09aa8,'select DATA "p1" from dbd_ora__drop_me where rowid = :rid for update',68,1,0)=SUCCESS OCIDescriptorAlloc(dccfe0,e84070,OCI_DTYPE_ROWID,0,0) OCIBindByName(e48228,e84068,e09aa8,":rid",placeh_len=4,value_p=e84070,value_sz=8,dty=104,indp=0,alenp=0,rcodep=0,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS lob refetch 1 for ':p1' param: ftype 113 setup OCIDefineByPos(e48228,7fffffffe030,e09aa8,1,e84d60,-1,113,e85870,0,e686d0,mode=DEFAULT,0)=SUCCESS OCIHandleFree(e4b7d0,OCI_HTYPE_DESCRIBE)=SUCCESS OCIAttrGet(e4ac70,OCI_HTYPE_STMT,e082f8,0,OCI_ATTR_ROWID,e09aa8)=SUCCESS OCIStmtExecute(e099c8,e48228,e09aa8,1,0,0,0,mode=DEFAULT,0)=SUCCESS OCILobCharSetForm(dccfe0,e09aa8,e07468,0)=SUCCESS OCILobCharSetId(dccfe0,e09aa8,e07468,0)=SUCCESS calling OCILobWrite fbh->csid=1 fbh->csform=0 amtp=540672 OCILobWrite(e099c8,e09aa8,e07468,7fffffffe2a0,1,7fffed9f5010,540672,0,0,0,1,0)=SUCCESS lob refetch 1 for ':p1' param: ftype 113, len 540672: LobWrite SUCCESS OCITransCommit(e099c8,e09aa8,0)=SUCCESS <- execute= ( 1 ) [1 items] at t/31lob.t line 48 via at t/31lob.t line 48 -> FETCH for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'LongReadLen') thr#77d010 .. FETCH DBI::db=HASH(0xc5e078) 'LongReadLen' = 80 <- FETCH= ( 80 ) [1 items] at t/31lob.t line 51 -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'LongReadLen' 1000000) thr#77d010 STORE DBI::db=HASH(0xc5e078) 'LongReadLen' => 1000000 <- STORE= ( 1 ) [1 items] at t/31lob.t line 51 -> selectrow_array for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'select data from dbd_ora__drop_me where id = 666') thr#77d010 1 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'select data from dbd_ora__drop_me where id = 666' undef) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5da48)=>DBI::st=HASH(0xc5de08), DBD::Oracle::st, c5d400, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5de08), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5de08), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) OCIHandleAlloc(dccfe0,e86168,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e4b380,e09aa8,'select data from dbd_ora__drop_me where id = 666',48,1,0)=SUCCESS OCIAttrGet(e4b380,OCI_HTYPE_STMT,e8617c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql SELECT ( auto_lob1, check_sql1) dbd_describe SELECT (EXPLICIT, lb 1000000)... OCIStmtExecute(e099c8,e4b380,e09aa8,0,0,0,0,mode=DESCRIBE_ONLY,16)=SUCCESS OCIAttrGet(e4b380,OCI_HTYPE_STMT,7fffffffdacc,0,OCI_ATTR_PARAM_COUNT,e09aa8)=SUCCESS OCIParamGet(e4b380,4,e09aa8,e851c0,1,OCI_HTYPE_STMT)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e851f0,0,OCI_ATTR_DATA_TYPE,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e851f2,0,OCI_ATTR_DATA_SIZE,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e85208,0,OCI_ATTR_CHAR_USED,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e8520a,0,OCI_ATTR_CHAR_SIZE,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e8520c,0,OCI_ATTR_CHARSET_ID,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e8520e,0,OCI_ATTR_CHARSET_FORM,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e851f4,0,OCI_ATTR_PRECISION,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e851f6,0,OCI_ATTR_SCALE,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e851f7,0,OCI_ATTR_IS_NULL,e09aa8)=SUCCESS OCIAttrGet(e914c8,OCI_DTYPE_PARAM,e851f8,7fffffffdac8,OCI_ATTR_NAME,e09aa8)=SUCCESS Describe col #1 type=113(SQLT_BLOB / long) OCIDescriptorAlloc(dccfe0,e851d0,OCI_DTYPE_LOB,0,0) Described col 1: dbtype 113(SQLT_BLOB / long), scale 0, prec 0, nullok 1, name DATA : dbsize 4000, char_used 0, char_size 0, csid 0, csform 0(0), disize 8 fbh 1: 'DATA' NULLable, otype 113->113, dbsize 4000/8, p0.s0 OCIAttrSet(e4b380,OCI_HTYPE_STMT, 7fffffffdac8,4,Attr=OCI_ATTR_PREFETCH_MEMORY,e09aa8)=SUCCESS OCIAttrSet(e4b380,OCI_HTYPE_STMT, 7fffffffdac4,4,Attr=OCI_ATTR_PREFETCH_ROWS,e09aa8)=SUCCESS cache settings DB Handle RowCacheSize=0,Statement Handle RowCacheSize=0, OCI_ATTR_PREFETCH_ROWS=1, OCI_ATTR_PREFETCH_MEMORY=0, Rows per Fetch=1, Multiple Row Fetch=Off OCIDefineByPos(e4b380,e851c8,e09aa8,1,e851d0,0,113,e85260,e85900,e85980,mode=DEFAULT,0)=SUCCESS dbd_describe'd 1 columns (row bytes: 4000 max, 4000 est avg, cache: 0) 1 <- prepare= ( DBI::st=HASH(0xc5da48) ) [1 items] at t/31lob.t line 52 dbd_st_execute SELECT (out0, lob0)... Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(e099c8,e4b380,e09aa8,0,0,0,0,mode=DEFAULT,0)=SUCCESS rs_array_init:imp_sth->rs_array_size=1, rs_array_idx=0, prefetch_rows=0, rs_array_status=SUCCESS OCIAttrGet(e4b380,OCI_HTYPE_STMT,7fffffffe37e,0,OCI_ATTR_SQLFNCODE,e09aa8)=SUCCESS dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0) dbd_st_fetch 1 fields... OCIStmtFetch(e4b380,e09aa8,1,2,0)=SUCCESS dbih_setup_fbav alloc for 1 fields dbih_setup_fbav now 1 fields dbd_st_fetched 1 fields with status of 0(SUCCESS) field #1 with rc=0(OK) OCILobGetLength(e099c8,e09aa8,e07348,7fffffffdfd8)=SUCCESS OCILobCharSetForm(dccfe0,e09aa8,e07348,0)=SUCCESS OCILobRead(e099c8,e09aa8,e07348,7fffffffdfd4,1,7fffed970010,540672,0,0,0,0)=SUCCESS OCILobRead field 1 of 1 SUCCESS: csform 0 (0), LOBlen 540672(bytes), LongReadLen 1000000(bytes), BufLen 540672(bytes), Got 540672(bytes) OCILobIsTemporary(dccfe0,e09aa8,e07348,7fffffffdf0c)=SUCCESS c5dc58 (field=0): ' !"#$...' dbd_st_finish OCIStmtFetch(e4b380,e09aa8,0,2,0)=SUCCESS <- selectrow_array= ( ' !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$...' ) [1 items] at t/31lob.t line 52 <> DESTROY(DBI::st=HASH(0xc5da48)) ignored for outer handle (inner DBI::st=HASH(0xc5de08) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5de08)~INNER) thr#77d010 dbd_st_destroy OCIHandleFree(e4b380,OCI_HTYPE_STMT)=SUCCESS OCIOCILobFileIsOpen_log_stat(e099c8,e09aa8,e07348,7fffffffdf7c,0)=INVALID_HANDLE OCIDescriptorFree(e07348,OCI_DTYPE_LOB) <- DESTROY= ( undef ) [1 items] at t/31lob.t line 53 via at t/31lob.t line 53 DESTROY (dbih_clearcom) (sth 0xc5de08, com 0xe86080, imp DBD::Oracle::st): FLAGS 0x102011: COMSET Warn PrintWarn ShowErrorStatement PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) LongReadLen 1000000 NUM_OF_FIELDS 1 NUM_OF_PARAMS 0 dbih_clearcom 0xc5de08 (com 0xe86080, type 3) done. -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'LongReadLen' 80) thr#77d010 STORE DBI::db=HASH(0xc5e078) 'LongReadLen' => 80 <- STORE= ( 1 ) [1 items] at t/31lob.t line 51 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'INSERT INTO dbd_ora__drop_me (id,data) VALUES (?, EMPTY_BLOB()) RETURNING data INTO ?' HASH(0xc5dbb0)) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5d5c8)=>DBI::st=HASH(0xb54748), DBD::Oracle::st, c5d2b0, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xb54748), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xb54748), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xb54748), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xb54748), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xb54748), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xb54748), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xb54748), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xb54748), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xb54748), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) dbd_preparse scanned 2 distinct placeholders OCIHandleAlloc(dccfe0,e86168,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e4b380,e09aa8,'INSERT INTO dbd_ora__drop_me (id,data) VALUES (:p1, EMPTY_BLOB()) RETURNING data INTO :p2',89,1,0)=SUCCESS OCIAttrGet(e4b380,OCI_HTYPE_STMT,e8617c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql INSERT ( auto_lob0, check_sql1) dbd_describe skipped for INSERT <- prepare= ( DBI::st=HASH(0xc5d5c8) ) [1 items] at t/31lob.t line 60 <> DESTROY(DBI::st=HASH(0xa32ee8)) ignored for outer handle (inner DBI::st=HASH(0xc5dd00) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5dd00)~INNER) thr#77d010 OCIHandleFree(e4b7d0,OCI_HTYPE_DESCRIBE)=INVALID_HANDLE dbd_st_destroy OCIHandleFree(e4ac70,OCI_HTYPE_STMT)=SUCCESS OCIDescriptorFree(e082f8,OCI_DTYPE_ROWID) OCIHandleFree(e48228,OCI_HTYPE_STMT)=SUCCESS OCIOCILobFileIsOpen_log_stat(e099c8,e09aa8,e07468,7fffffffdf3c,32767)=INVALID_HANDLE OCIDescriptorFree(e07468,OCI_DTYPE_LOB) OCILobIsTemporary(dccfe0,e09aa8,e07558,7fffffffdf7c)=SUCCESS OCIDescriptorFree(e07558,OCI_DTYPE_LOB) <- DESTROY= ( undef ) [1 items] at t/31lob.t line 61 via at t/31lob.t line 61 DESTROY (dbih_clearcom) (sth 0xc5dd00, com 0xe84520, imp DBD::Oracle::st): FLAGS 0x182011: COMSET Warn PrintWarn ShowErrorStatement PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) NUM_OF_FIELDS -1 NUM_OF_PARAMS 1 dbih_clearcom 0xc5dd00 (com 0xe84520, type 3) done. -> bind_param for DBD::Oracle::st (DBI::st=HASH(0xc5d5c8)~0xb54748 1 2) thr#77d010 dbd_bind_ph(1): bind :p1 <== 2 (type 0 (DEFAULT (varchar))) dbd_rebind_ph() (1): rebinding :p1 as NULL (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 0) dbd_rebind_ph_char() (1): bind :p1 <== 2 (size 1/16/0, ptype 5(VARCHAR), otype 1 ) dbd_rebind_ph_char() (2): bind :p1 <== 2 (size 1/16, otype 1(VARCHAR), indp 0, at_exec 1) bind :p1 as ftype 1 (VARCHAR) OCIBindByName(e4b380,e967b8,e09aa8,":p1",placeh_len=3,value_p=e84e10,value_sz=16,dty=1,indp=e967d8,alenp=0,rcodep=e967d0,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS OCIBindDynamic(e92228,e09aa8,e96780,7ffff671d590,e96780,7ffff671d830)=SUCCESS OCIAttrGet(e92228,OCI_HTYPE_BIND,e9679c,0,31,e09aa8)=SUCCESS dbd_rebind_ph(): bind :p1 <== 2 (in, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 16, maxdata_size 0) OCIAttrSet(e92228,OCI_HTYPE_BIND, 7fffffffe29c,0,Attr=31,e09aa8)=SUCCESS <- bind_param= ( 1 ) [1 items] at t/31lob.t line 61 -> bind_param_inout for DBD::Oracle::st (DBI::st=HASH(0xc5d5c8)~0xb54748 2 SCALAR(0x8e79b0) 0 HASH(0xc5dbb0)) thr#77d010 dbd_bind_ph(1): bind :p2 <== undef (type 0 (DEFAULT (varchar)), inout 0x8e79b0, maxlen 0, attribs: HASH(0xc5dbb0)) dbd_rebind_ph() (1): rebinding :p2 as NULL (not-utf8, ftype 113 (SQLT_BLOB / long), csid 0, csform 0(0), inout 1) OCIDescriptorAlloc(dccfe0,e96880,OCI_DTYPE_LOB,0,0) OCIAttrSet(e07558,OCI_DTYPE_LOB, 7fffffffe178,0,Attr=OCI_ATTR_LOBEMPTY,e09aa8)=SUCCESS bind :p2 as ftype 113 (SQLT_BLOB / long) OCIBindByName(e4b380,e96878,e09aa8,":p2",placeh_len=3,value_p=e96880,value_sz=8,dty=113,indp=e96898,alenp=0,rcodep=e96890,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS OCIAttrGet(e92038,OCI_HTYPE_BIND,e9685c,0,31,e09aa8)=SUCCESS dbd_rebind_ph(): bind :p2 <== undef (inout, not-utf8, csid 0->0->0, ftype 113 (SQLT_BLOB / long), csform 0(0)->0(0), maxlen 8, maxdata_size 0) <- bind_param_inout= ( 1 ) [1 items] at t/31lob.t line 62 -> execute for DBD::Oracle::st (DBI::st=HASH(0xc5d5c8)~0xb54748) thr#77d010 dbd_st_execute INSERT (out1, lob1)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(e099c8,e4b380,e09aa8,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(e4b380,OCI_HTYPE_STMT,7fffffffe378,0,OCI_ATTR_ROW_COUNT,e09aa8)=SUCCESS OCIAttrGet(e4b380,OCI_HTYPE_STMT,7fffffffe37e,0,OCI_ATTR_SQLFNCODE,e09aa8)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out1) dbd_st_execute(): Analyzing inout a parameter ':p2of type=113 name=SQLT_BLOB / long' <- execute= ( 1 ) [1 items] at t/31lob.t line 63 <> FETCH= ( 1 ) [1 items] ('AutoCommit' from cache) at t/31lob.t line 87 -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'AutoCommit' 0) thr#77d010 <- STORE= ( 1 ) [1 items] at t/31lob.t line 87 -> do in DBD::_::db for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'INSERT INTO dbd_ora__drop_me (id,data) VALUES (3, EMPTY_BLOB())') thr#77d010 1 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'INSERT INTO dbd_ora__drop_me (id,data) VALUES (3, EMPTY_BLOB())' undef) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5da18)=>DBI::st=HASH(0xc5d940), DBD::Oracle::st, c5d220, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5d940), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d940), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d940), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d940), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d940), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d940), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d940), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d940), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d940), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) OCIHandleAlloc(dccfe0,e84608,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e48228,e09aa8,'INSERT INTO dbd_ora__drop_me (id,data) VALUES (3, EMPTY_BLOB())',63,1,0)=SUCCESS OCIAttrGet(e48228,OCI_HTYPE_STMT,e8461c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql INSERT ( auto_lob1, check_sql1) dbd_describe skipped for INSERT 1 <- prepare= ( DBI::st=HASH(0xc5da18) ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1611 via at t/31lob.t line 92 -> execute for DBD::Oracle::st (DBI::st=HASH(0xc5da18)~0xc5d940) thr#77d010 dbd_st_execute INSERT (out0, lob0)... Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(e099c8,e48228,e09aa8,1,0,0,0,mode=DEFAULT,0)=SUCCESS OCIAttrGet(e48228,OCI_HTYPE_STMT,7fffffffdeb8,0,OCI_ATTR_ROW_COUNT,e09aa8)=SUCCESS OCIAttrGet(e48228,OCI_HTYPE_STMT,7fffffffdebe,0,OCI_ATTR_SQLFNCODE,e09aa8)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) <- execute= ( 1 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1612 via at t/31lob.t line 92 -> rows for DBD::Oracle::st (DBI::st=HASH(0xc5da18)~0xc5d940) thr#77d010 OCIAttrGet(e48228,OCI_HTYPE_STMT,7fffffffdedc,0,OCI_ATTR_ROW_COUNT,e09aa8)=SUCCESS <- rows= ( 1 ) [1 items] at /software/perl-5.16.0/lib/site_perl/5.16.0/x86_64-linux-thread-multi/DBI.pm line 1613 via at t/31lob.t line 92 <> DESTROY(DBI::st=HASH(0xc5da18)) ignored for outer handle (inner DBI::st=HASH(0xc5d940) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5d940)~INNER) thr#77d010 dbd_st_destroy OCIHandleFree(e48228,OCI_HTYPE_STMT)=SUCCESS <- DESTROY= ( undef ) [1 items] at t/31lob.t line 92 via at t/31lob.t line 92 DESTROY (dbih_clearcom) (sth 0xc5d940, com 0xe84520, imp DBD::Oracle::st): FLAGS 0x182011: COMSET Warn PrintWarn ShowErrorStatement PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) NUM_OF_FIELDS -1 NUM_OF_PARAMS 0 dbih_clearcom 0xc5d940 (com 0xe84520, type 3) done. <- do= ( 1 ) [1 items] at t/31lob.t line 92 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'SELECT data FROM dbd_ora__drop_me WHERE id = ?' HASH(0xc5ddd8)) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5d3e8)=>DBI::st=HASH(0xc5d7a8), DBD::Oracle::st, c58220, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d7a8), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) dbd_preparse scanned 1 distinct placeholders OCIHandleAlloc(dccfe0,e84608,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e48228,e09aa8,'SELECT data FROM dbd_ora__drop_me WHERE id = :p1',48,1,0)=SUCCESS OCIAttrGet(e48228,OCI_HTYPE_STMT,e8461c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql SELECT ( auto_lob0, check_sql1) dbd_describe SELECT (EXPLICIT, lb 80)... OCIStmtExecute(e099c8,e48228,e09aa8,0,0,0,0,mode=DESCRIBE_ONLY,16)=SUCCESS OCIAttrGet(e48228,OCI_HTYPE_STMT,7fffffffe01c,0,OCI_ATTR_PARAM_COUNT,e09aa8)=SUCCESS OCIParamGet(e48228,4,e09aa8,e96910,1,OCI_HTYPE_STMT)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e96940,0,OCI_ATTR_DATA_TYPE,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e96942,0,OCI_ATTR_DATA_SIZE,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e96958,0,OCI_ATTR_CHAR_USED,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e9695a,0,OCI_ATTR_CHAR_SIZE,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e9695c,0,OCI_ATTR_CHARSET_ID,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e9695e,0,OCI_ATTR_CHARSET_FORM,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e96944,0,OCI_ATTR_PRECISION,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e96946,0,OCI_ATTR_SCALE,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e96947,0,OCI_ATTR_IS_NULL,e09aa8)=SUCCESS OCIAttrGet(e499d0,OCI_DTYPE_PARAM,e96948,7fffffffe018,OCI_ATTR_NAME,e09aa8)=SUCCESS Describe col #1 type=113(SQLT_BLOB / long) OCIDescriptorAlloc(dccfe0,e96920,OCI_DTYPE_LOB,0,0) Described col 1: dbtype 113(SQLT_BLOB / long), scale 0, prec 0, nullok 1, name DATA : dbsize 4000, char_used 0, char_size 0, csid 0, csform 0(0), disize 8 fbh 1: 'DATA' NULLable, otype 113->113, dbsize 4000/8, p0.s0 OCIAttrSet(e48228,OCI_HTYPE_STMT, 7fffffffe018,4,Attr=OCI_ATTR_PREFETCH_MEMORY,e09aa8)=SUCCESS OCIAttrSet(e48228,OCI_HTYPE_STMT, 7fffffffe014,4,Attr=OCI_ATTR_PREFETCH_ROWS,e09aa8)=SUCCESS cache settings DB Handle RowCacheSize=0,Statement Handle RowCacheSize=0, OCI_ATTR_PREFETCH_ROWS=1, OCI_ATTR_PREFETCH_MEMORY=0, Rows per Fetch=1, Multiple Row Fetch=Off OCIDefineByPos(e48228,e96918,e09aa8,1,e96920,0,113,e85520,e84be0,e8a230,mode=DEFAULT,0)=SUCCESS dbd_describe'd 1 columns (row bytes: 4000 max, 4000 est avg, cache: 0) <- prepare= ( DBI::st=HASH(0xc5d3e8) ) [1 items] at t/31lob.t line 94 <> DESTROY(DBI::st=HASH(0xc5d5c8)) ignored for outer handle (inner DBI::st=HASH(0xb54748) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xb54748)~INNER) thr#77d010 dbd_st_destroy OCIHandleFree(e4b380,OCI_HTYPE_STMT)=SUCCESS OCILobIsTemporary(dccfe0,e09aa8,e07558,7fffffffdf7c)=SUCCESS OCIDescriptorFree(e07558,OCI_DTYPE_LOB) <- DESTROY= ( undef ) [1 items] at t/31lob.t line 95 via at t/31lob.t line 95 DESTROY (dbih_clearcom) (sth 0xb54748, com 0xe86080, imp DBD::Oracle::st): FLAGS 0x182011: COMSET Warn PrintWarn ShowErrorStatement PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) NUM_OF_FIELDS -1 NUM_OF_PARAMS 2 dbih_clearcom 0xb54748 (com 0xe86080, type 3) done. -> bind_param for DBD::Oracle::st (DBI::st=HASH(0xc5d3e8)~0xc5d7a8 1 3) thr#77d010 dbd_bind_ph(1): bind :p1 <== 3 (type 0 (DEFAULT (varchar))) dbd_rebind_ph() (1): rebinding :p1 as NULL (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 0) dbd_rebind_ph_char() (1): bind :p1 <== 3 (size 1/16/0, ptype 5(VARCHAR), otype 1 ) dbd_rebind_ph_char() (2): bind :p1 <== 3 (size 1/16, otype 1(VARCHAR), indp 0, at_exec 1) bind :p1 as ftype 1 (VARCHAR) OCIBindByName(e48228,e84d88,e09aa8,":p1",placeh_len=3,value_p=e84e10,value_sz=16,dty=1,indp=e84da8,alenp=0,rcodep=e84da0,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS OCIBindDynamic(e97e28,e09aa8,e84d50,7ffff671d590,e84d50,7ffff671d830)=SUCCESS OCIAttrGet(e97e28,OCI_HTYPE_BIND,e84d6c,0,31,e09aa8)=SUCCESS dbd_rebind_ph(): bind :p1 <== 3 (in, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 16, maxdata_size 0) OCIAttrSet(e97e28,OCI_HTYPE_BIND, 7fffffffe29c,0,Attr=31,e09aa8)=SUCCESS <- bind_param= ( 1 ) [1 items] at t/31lob.t line 96 -> execute for DBD::Oracle::st (DBI::st=HASH(0xc5d3e8)~0xc5d7a8) thr#77d010 dbd_st_execute SELECT (out0, lob0)... Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(e099c8,e48228,e09aa8,0,0,0,0,mode=DEFAULT,0)=SUCCESS rs_array_init:imp_sth->rs_array_size=1, rs_array_idx=0, prefetch_rows=0, rs_array_status=SUCCESS OCIAttrGet(e48228,OCI_HTYPE_STMT,7fffffffe37e,0,OCI_ATTR_SQLFNCODE,e09aa8)=SUCCESS dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0) <- execute= ( '0E0' ) [1 items] at t/31lob.t line 97 -> fetchrow for DBD::Oracle::st (DBI::st=HASH(0xc5d3e8)~0xc5d7a8) thr#77d010 dbd_st_fetch 1 fields... OCIStmtFetch(e48228,e09aa8,1,2,0)=SUCCESS dbih_setup_fbav alloc for 1 fields dbih_setup_fbav now 1 fields dbd_st_fetched 1 fields with status of 0(SUCCESS) field #1 with rc=0(OK) c5da18 (field=0): OCILobLocatorPtr=SCALAR(0xc5d8e0) <- fetchrow= ( OCILobLocatorPtr=SCALAR(0xc5d8e0) ) [1 items] row1 at t/31lob.t line 98 -> ora_lob_is_init for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 OCILobLocatorPtr=SCALAR(0xc5d8e0)) thr#77d010 OCIOCILobLocatorIsInit_log_stat(dccfe0,e09aa8,e07468,1)=SUCCESS <- ora_lob_is_init= ( 1 ) [1 items] at t/31lob.t line 102 -> ora_lob_write for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 OCILobLocatorPtr=SCALAR(0xc5d8e0) 1 'ABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABC...') thr#77d010 OCILobCharSetForm(dccfe0,e09aa8,e07468,0)=SUCCESS OCILobCharSetId(dccfe0,e09aa8,e07468,0)=SUCCESS OCILobWrite(e099c8,e09aa8,e07468,7fffffffe3c8,1,faad20,40000,0,0,0,0,0)=SUCCESS <- ora_lob_write= ( 1 ) [1 items] at t/31lob.t line 107 -> ora_lob_length for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 OCILobLocatorPtr=SCALAR(0xc5d8e0)) thr#77d010 OCILobGetLength(e099c8,e09aa8,e07468,7fffffffe3cc)=SUCCESS <- ora_lob_length= ( 40000 ) [1 items] at t/31lob.t line 109 via at t/31lob.t line 108 -> ora_lob_read for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 OCILobLocatorPtr=SCALAR(0xc5d8e0) 1 40000) thr#77d010 OCILobCharSetForm(dccfe0,e09aa8,e07468,0)=SUCCESS OCIOCILobFileIsOpen_log_stat(e099c8,e09aa8,e07468,7fffffffe3c4,0)=INVALID_HANDLE OCILobRead(e099c8,e09aa8,e07468,7fffffffe3c8,1,fb4970,160008,0,0,0,0)=SUCCESS <- ora_lob_read= ( 'ABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABCDABC...' ) [1 items] at t/31lob.t line 118 -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 'BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;' HASH(0xc5d238)) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5db08)=>DBI::st=HASH(0xc5d5e0), DBD::Oracle::st, c581c0, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d5e0), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) dbd_preparse scanned 2 distinct placeholders OCIHandleAlloc(dccfe0,e85b68,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e47b50,e09aa8,'BEGIN :p1 := DBMS_LOB.GETLENGTH( :p2 ); END;',44,1,0)=SUCCESS OCIAttrGet(e47b50,OCI_HTYPE_STMT,e85b7c,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql BEGIN ( auto_lob0, check_sql1) dbd_describe skipped for BEGIN <- prepare= ( DBI::st=HASH(0xc5db08) ) [1 items] at t/31lob.t line 127 <> DESTROY(DBI::st=HASH(0xc5d3e8)) ignored for outer handle (inner DBI::st=HASH(0xc5d7a8) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5d7a8)~INNER) thr#77d010 dbd_st_finish OCIStmtFetch(e48228,e09aa8,0,2,0)=SUCCESS dbd_st_destroy OCIHandleFree(e48228,OCI_HTYPE_STMT)=SUCCESS OCIOCILobFileIsOpen_log_stat(e099c8,e09aa8,e07468,7fffffffdf7c,0)=INVALID_HANDLE OCIDescriptorFree(e07468,OCI_DTYPE_LOB) <- DESTROY= ( undef ) [1 items] at t/31lob.t line 128 via at t/31lob.t line 128 DESTROY (dbih_clearcom) (sth 0xc5d7a8, com 0xe84520, imp DBD::Oracle::st): FLAGS 0x182011: COMSET Warn PrintWarn ShowErrorStatement PARENT DBI::db=HASH(0xc5e078) KIDS 0 (0 Active) NUM_OF_FIELDS 1 NUM_OF_PARAMS 1 dbih_clearcom 0xc5d7a8 (com 0xe84520, type 3) done. -> bind_param_inout for DBD::Oracle::st (DBI::st=HASH(0xc5db08)~0xc5d5e0 1 SCALAR(0xb4a410) 16) thr#77d010 dbd_bind_ph(1): bind :p1 <== 40000 (type 0 (DEFAULT (varchar)), inout 0xb4a410, maxlen 16) dbd_rebind_ph() (1): rebinding :p1 as NULL (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 1) dbd_rebind_ph_char() (1): bind :p1 <== 40000 (size 5/16/16, ptype 5(VARCHAR), otype 1 , inout) dbd_rebind_ph_char() (2): bind :p1 <== 40000 (size 5/32, otype 1(VARCHAR), indp 0, at_exec 1) bind :p1 as ftype 1 (VARCHAR) OCIBindByName(e47b50,e96c48,e09aa8,":p1",placeh_len=3,value_p=e859c0,value_sz=32,dty=1,indp=e96c68,alenp=0,rcodep=e96c60,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS OCIBindDynamic(e4b7b8,e09aa8,e96c10,7ffff671d590,e96c10,7ffff671d830)=SUCCESS OCIAttrGet(e4b7b8,OCI_HTYPE_BIND,e96c2c,0,31,e09aa8)=SUCCESS dbd_rebind_ph(): bind :p1 <== 40000 (inout, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 32, maxdata_size 0) OCIAttrSet(e4b7b8,OCI_HTYPE_BIND, 7fffffffe29c,0,Attr=31,e09aa8)=SUCCESS <- bind_param_inout= ( 1 ) [1 items] at t/31lob.t line 128 -> bind_param for DBD::Oracle::st (DBI::st=HASH(0xc5db08)~0xc5d5e0 2 OCILobLocatorPtr=SCALAR(0xc5d8e0) HASH(0xc5d610)) thr#77d010 dbd_bind_ph(1): bind :p2 <== OCILobLocatorPtr=SCALAR(0xc5d8e0) (type 0 (DEFAULT (varchar)), attribs: HASH(0xc5d610)) dbd_rebind_ph() (1): rebinding :p2 as NULL (not-utf8, ftype 113 (SQLT_BLOB / long), csid 0, csform 0(0), inout 0) OCIDescriptorAlloc(dccfe0,e96d10,OCI_DTYPE_LOB,0,0) OCIAttrSet(e07558,OCI_DTYPE_LOB, 7fffffffe178,0,Attr=OCI_ATTR_LOBEMPTY,e09aa8)=SUCCESS OCILobLocatorAssign(e099c8,e09aa8,e07468,e96d10)=SUCCESS bind :p2 as ftype 113 (SQLT_BLOB / long) OCIBindByName(e47b50,e96d08,e09aa8,":p2",placeh_len=3,value_p=e96d10,value_sz=8,dty=113,indp=e96d28,alenp=0,rcodep=e96d20,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS OCIAttrGet(e4b5c8,OCI_HTYPE_BIND,e96cec,0,31,e09aa8)=SUCCESS dbd_rebind_ph(): bind :p2 <== OCILobLocatorPtr=SCALAR(0xc5d8e0) (in, not-utf8, csid 0->0->0, ftype 113 (SQLT_BLOB / long), csform 0(0)->0(0), maxlen 8, maxdata_size 0) <- bind_param= ( 1 ) [1 items] at t/31lob.t line 129 -> execute for DBD::Oracle::st (DBI::st=HASH(0xc5db08)~0xc5d5e0) thr#77d010 dbd_st_execute BEGIN (out1, lob1)... with :p1 = '40000' (len 5(5)/32, indp 0, otype 1, ptype 6) Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(e099c8,e47b50,e09aa8,1,0,0,0,mode=DEFAULT,0)=ERROR OCIAttrGet(e47b50,OCI_HTYPE_STMT,7fffffffe23e,0,OCI_ATTR_PARSE_ERROR_OFFSET,e09aa8)=SUCCESS OCIErrorGet(e09aa8,1,"",7fffffffde3c,"ORA-24813: cannot send or receive an unsupported LOB ",1024,2)=SUCCESS OCIErrorGet after OCIStmtExecute (er1:ok): -1, 24813: ORA-24813: cannot send or receive an unsupported LOB OCIErrorGet(e09aa8,2,"",7fffffffde3c,"ORA-24813: cannot send or receive an unsupported LOB ",1024,2)=NO_DATA !! ERROR: 24813 'ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)' (err#1) <- execute= ( undef ) [1 items] at t/31lob.t line 130 1 -> FETCH for DBD::Oracle::st (DBI::st=HASH(0xc5d5e0)~INNER 'ParamValues') thr#77d010 ERROR: 24813 'ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)' (err#1) 1 <- FETCH= ( HASH(0xc5d598)2keys ) [1 items] at t/31lob.t line 130 -> err in DBD::_::common for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078) thr#77d010 ERROR: 24813 'ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)' (err#0) <- err= ( 24813 ) [1 items] at t/31lob.t line 137 -> err in DBD::_::common for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078) thr#77d010 ERROR: 24813 'ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)' (err#0) <- err= ( 24813 ) [1 items] at t/31lob.t line 137 -> err in DBD::_::common for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078) thr#77d010 ERROR: 24813 'ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)' (err#0) <- err= ( 24813 ) [1 items] at t/31lob.t line 137 -> err in DBD::_::common for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078) thr#77d010 ERROR: 24813 'ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)' (err#0) <- err= ( 24813 ) [1 items] at t/31lob.t line 137 -> err in DBD::_::common for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078) thr#77d010 ERROR: 24813 'ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)' (err#0) <- err= ( 24813 ) [1 items] at t/31lob.t line 137 -> STORE for DBD::Oracle::db (DBI::db=HASH(0xc5e078)~INNER 'LongReadLen' 80000) thr#77d010 STORE DBI::db=HASH(0xc5e078) 'LongReadLen' => 80000 ERROR: 24813 'ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute)' (err#0) <- STORE= ( 1 ) [1 items] at t/31lob.t line 154 !! ERROR: 24813 CLEARED by call to prepare method -> prepare for DBD::Oracle::db (DBI::db=HASH(0xc5df58)~0xc5e078 ' DECLARE -- testing IN, OUT, and IN OUT: -- p_out will be set to LOWER(p_in) -- p_inout will be set to p_inout || p_in PROCEDURE lower_lob(p_in BLOB, p_out OUT BLOB, p_inout IN OUT BLOB) IS pos INT; buffer RAW(1024); BEGIN DBMS_LOB.CREATETEMPORARY(p_out, TRUE); pos := 1; WHILE pos <= DBMS_LOB.GETLENGTH(p_in) LOOP buffer := DBMS_LOB.SUBSTR(p_in, 1024, pos); DBMS_LOB.WRITEAPPEND(p_out, UTL_RAW.LENGTH(buffer), UTL_RAW.CAST_TO_RAW(LOWER(UTL_RAW.CAST_TO_VARCHAR2(buffer)))); DBMS_LOB.WRITEAPPEND(p_inout, UTL_RAW.LENGTH(buffer), buffer); pos := pos + 1024; END LOOP; END; BEGIN lower_lob(:in, :out, :inout); END; ' HASH(0xb8a410)) thr#77d010 New 'DBI::st' (for DBD::Oracle::st, parent=DBI::db=HASH(0xc5e078), id=undef) dbih_setup_handle(DBI::st=HASH(0xc5d7a8)=>DBI::st=HASH(0xc5d910), DBD::Oracle::st, c57ef0, Null!) dbih_make_com(DBI::db=HASH(0xc5e078), c03f90, DBD::Oracle::st, 464, 0) thr#77d010 dbih_setup_attrib(DBI::st=HASH(0xc5d910), Err, DBI::db=HASH(0xc5e078)) SCALAR(0xa32cd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d910), State, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d98) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d910), Errstr, DBI::db=HASH(0xc5e078)) SCALAR(0xa32d38) (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d910), TraceLevel, DBI::db=HASH(0xc5e078)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d910), FetchHashKeyName, DBI::db=HASH(0xc5e078)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xc5d910), HandleSetErr, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d910), HandleError, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d910), ReadOnly, DBI::db=HASH(0xc5e078)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xc5d910), Profile, DBI::db=HASH(0xc5e078)) undef (not defined) dbd_preparse scanned 3 distinct placeholders OCIHandleAlloc(dccfe0,e845e8,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(e48228,e09aa8,' DECLARE -- testing IN, OUT, and IN OUT: -- p_out will be set to LOWER(p_in) -- p_inout will be set to p_inout || p_in PROCEDURE lower_lob(p_in BLOB, p_out OUT BLOB, p_inout IN OUT BLOB) IS pos INT; buffer RAW(1024); BEGIN DBMS_LOB.CREATETEMPORARY(p_out, TRUE); pos := 1; WHILE pos <= DBMS_LOB.GETLENGTH(p_in) LOOP buffer := DBMS_LOB.SUBSTR(p_in, 1024, pos); DBMS_LOB.WRITEAPPEND(p_out, UTL_RAW.LENGTH(buffer), UTL_RAW.CAST_TO_RAW(LOWER(UTL_RAW.CAST_TO_VARCHAR2(buffer)))); DBMS_LOB.WRITEAPPEND(p_inout, UTL_RAW.LENGTH(buffer), buffer); pos := pos + 1024; END LOOP; END; BEGIN lower_lob(:in, :out, :inout); END; ',738,1,0)=SUCCESS OCIAttrGet(e48228,OCI_HTYPE_STMT,e845fc,0,OCI_ATTR_STMT_TYPE,e09aa8)=SUCCESS dbd_st_prepare'd sql DECLARE ( auto_lob1, check_sql1) dbd_describe skipped for DECLARE <- prepare= ( DBI::st=HASH(0xc5d7a8) ) [1 items] at t/31lob.t line 160 via at t/31lob.t line 159 <> DESTROY(DBI::st=HASH(0xc5db08)) ignored for outer handle (inner DBI::st=HASH(0xc5d5e0) has ref cnt 1) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0xc5d5e0)~INNER) thr#77d010 dbd_st_destroy OCIHandleFree(e47b50,OCI_HTYPE_STMT)=SUCCESS OCILobIsTemporary(dccfe0,e09aa8,e07558,7fffffffdf7c)=SUCCESS OCIDescriptorFree(e07558,OCI_DTYPE_LOB) 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 Errors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x000E07538], [0], [0], [0], [], [], [] ˆ¿šõÿˆ¿šõÿErrors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x000E07538], [0], [0], [0], [], [], [] ˆ¿šõÿˆ¿šõÿˆ¿šõÿˆ¿šõÿˆ¿šõÿˆ¿šõÿ Dubious, test returned 1 (wstat 256, 0x100) Failed 3/12 subtests (1 TODO test unexpectedly succeeded) Test Summary Report ------------------- t/31lob.t (Wstat: 256 Tests: 9 Failed: 0) TODO passed: 9 Non-zero exit status: 1 Parse errors: Bad plan. You planned 12 tests but ran 9. Files=1, Tests=9, 1 wallclock secs ( 0.05 usr 0.00 sys + 0.09 cusr 0.04 csys = 0.18 CPU) Result: FAIL Failed 1/1 test programs. 0/9 subtests failed.