With the log level set to 15 here are the first 200 lines of log
AAA::DBI::Connection::db=HASH(0x3abce00) trace level set to 0x0/15 (DBI @
0x0/0) in DBI 1.637-ithread (pid 12594)
-> STORE for DBD::Oracle::db
(AAA::DBI::Connection::db=HASH(0x3abce00)~INNER 'RowCacheSize' 2097152)
thr#24d4010
<- STORE= ( 1 ) [1 items] at /dirname/scriptname.pl line 78
-> prepare for DBD::Oracle::db
(AAA::DBI::Connection::db=HASH(0x3abcef0)~0x3abce00 'SELECT [ yada yada yada
]') thr#24d4010
New 'AAA::DBI::Connection::st' (for DBD::Oracle::st,
parent=AAA::DBI::Connection::db=HASH(0x3abce00), id=undef)
dbih_setup_handle(AAA::DBI::Connection::st=HASH(0x3abd310)=>AAA::DBI::Connection::st=HASH(0x39f75f0),
DBD::Oracle::st, 268ae18, Null!)
dbih_make_com(AAA::DBI::Connection::db=HASH(0x3abce00), 3abdfc0,
DBD::Oracle::st, 464, 0) thr#24d4010
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0), Err,
AAA::DBI::Connection::db=HASH(0x3abce00)) SCALAR(0x268acc8) (already defined)
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0), State,
AAA::DBI::Connection::db=HASH(0x3abce00)) SCALAR(0x268ad88) (already defined)
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0), Errstr,
AAA::DBI::Connection::db=HASH(0x3abce00)) SCALAR(0x268ad28) (already defined)
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0), TraceLevel,
AAA::DBI::Connection::db=HASH(0x3abce00)) 15 (already defined)
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0),
FetchHashKeyName, AAA::DBI::Connection::db=HASH(0x3abce00)) 'NAME' (already
defined)
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0), HandleSetErr,
AAA::DBI::Connection::db=HASH(0x3abce00)) undef (not defined)
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0), HandleError,
AAA::DBI::Connection::db=HASH(0x3abce00)) undef (not defined)
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0), ReadOnly,
AAA::DBI::Connection::db=HASH(0x3abce00)) undef (not defined)
dbih_setup_attrib(AAA::DBI::Connection::st=HASH(0x39f75f0), Profile,
AAA::DBI::Connection::db=HASH(0x3abce00)) undef (not defined)
OCIHandleAlloc(3b2c0f0,3be0cc8,OCI_HTYPE_STMT,0,0)=SUCCESS
OCIStmtPrepare(3ba3190,3b535c8,'SELECT [ yada yada yada
]',513,1,0)=SUCCESS
OCIAttrGet(3ba3190,OCI_HTYPE_STMT,3be0cdc,0,OCI_ATTR_STMT_TYPE,3b535c8)=SUCCESS
dbd_st_prepare'd sql SELECT ( auto_lob1, check_sql1)
dbd_describe SELECT (EXPLICIT, lb 80)...
OCIStmtExecute(3b5b028,3ba3190,3b535c8,0,0,0,0,mode=DESCRIBE_ONLY,16)=SUCCESS
OCIAttrGet(3ba3190,OCI_HTYPE_STMT,7ffd7b72baa4,0,OCI_ATTR_PARAM_COUNT,3b535c8)=SUCCESS
OCIParamGet(3ba3190,4,3b535c8,3be10e0,1,OCI_HTYPE_STMT)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be1110,0,OCI_ATTR_DATA_TYPE,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be1112,0,OCI_ATTR_DATA_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be1128,0,OCI_ATTR_CHAR_USED,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be112a,0,OCI_ATTR_CHAR_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be112c,0,OCI_ATTR_CHARSET_ID,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be112e,0,OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be1114,0,OCI_ATTR_PRECISION,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be1116,0,OCI_ATTR_SCALE,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be1117,0,OCI_ATTR_IS_NULL,3b535c8)=SUCCESS
OCIAttrGet(3ba2e90,OCI_DTYPE_PARAM,3be1118,7ffd7b72baac,OCI_ATTR_NAME,3b535c8)=SUCCESS
Describe col #1 type=2(NVARCHAR2)
Described col 1: dbtype 2(NVARCHAR2), scale -127, prec 0, nullok 1, name
ROW_NUMBER
: dbsize 22, char_used 0, char_size 0, csid 0, csform 0(0),
disize 171
fbh 1: 'ROW_NUMBER' NULLable, otype 2-> 5, dbsize 22/172,
p0.s-127
OCIParamGet(3ba3190,4,3b535c8,3be1188,2,OCI_HTYPE_STMT)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11b8,0,OCI_ATTR_DATA_TYPE,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11ba,0,OCI_ATTR_DATA_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11d0,0,OCI_ATTR_CHAR_USED,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11d2,0,OCI_ATTR_CHAR_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11d4,0,OCI_ATTR_CHARSET_ID,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11d6,0,OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11bc,0,OCI_ATTR_PRECISION,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11be,0,OCI_ATTR_SCALE,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11bf,0,OCI_ATTR_IS_NULL,3b535c8)=SUCCESS
OCIAttrGet(3ba07a0,OCI_DTYPE_PARAM,3be11c0,7ffd7b72baac,OCI_ATTR_NAME,3b535c8)=SUCCESS
Describe col #2 type=2(NVARCHAR2)
Described col 2: dbtype 2(NVARCHAR2), scale 0, prec 12, nullok 0, name F1
: dbsize 22, char_used 0, char_size 0, csid 0, csform 0(0),
disize 171
fbh 2: 'F1' NO null , otype 2-> 5, dbsize 22/172, p12.s0
OCIParamGet(3ba3190,4,3b535c8,3be1230,3,OCI_HTYPE_STMT)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be1260,0,OCI_ATTR_DATA_TYPE,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be1262,0,OCI_ATTR_DATA_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be1278,0,OCI_ATTR_CHAR_USED,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be127a,0,OCI_ATTR_CHAR_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be127c,0,OCI_ATTR_CHARSET_ID,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be127e,0,OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be1264,0,OCI_ATTR_PRECISION,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be1266,0,OCI_ATTR_SCALE,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be1267,0,OCI_ATTR_IS_NULL,3b535c8)=SUCCESS
OCIAttrGet(3ba0700,OCI_DTYPE_PARAM,3be1268,7ffd7b72baac,OCI_ATTR_NAME,3b535c8)=SUCCESS
Describe col #3 type=1(VARCHAR)
Described col 3: dbtype 1(VARCHAR), scale 0, prec 20, nullok 0, name F2
: dbsize 20, char_used 0, char_size 20, csid 31, csform
1(SQLCS_IMPLICIT), disize 20
fbh 3: 'F2' NO null , otype 1-> 5, dbsize 20/21, p20.s0
OCIParamGet(3ba3190,4,3b535c8,3be12d8,4,OCI_HTYPE_STMT)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be1308,0,OCI_ATTR_DATA_TYPE,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be130a,0,OCI_ATTR_DATA_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be1320,0,OCI_ATTR_CHAR_USED,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be1322,0,OCI_ATTR_CHAR_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be1324,0,OCI_ATTR_CHARSET_ID,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be1326,0,OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be130c,0,OCI_ATTR_PRECISION,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be130e,0,OCI_ATTR_SCALE,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be130f,0,OCI_ATTR_IS_NULL,3b535c8)=SUCCESS
OCIAttrGet(3ba06b0,OCI_DTYPE_PARAM,3be1310,7ffd7b72baac,OCI_ATTR_NAME,3b535c8)=SUCCESS
Describe col #4 type=2(NVARCHAR2)
Described col 4: dbtype 2(NVARCHAR2), scale 3, prec 15, nullok 1, name F3
: dbsize 22, char_used 0, char_size 0, csid 0, csform 0(0),
disize 171
fbh 4: 'F3' NULLable, otype 2-> 5, dbsize 22/172, p15.s3
OCIParamGet(3ba3190,4,3b535c8,3be1380,5,OCI_HTYPE_STMT)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13b0,0,OCI_ATTR_DATA_TYPE,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13b2,0,OCI_ATTR_DATA_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13c8,0,OCI_ATTR_CHAR_USED,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13ca,0,OCI_ATTR_CHAR_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13cc,0,OCI_ATTR_CHARSET_ID,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13ce,0,OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13b4,0,OCI_ATTR_PRECISION,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13b6,0,OCI_ATTR_SCALE,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13b7,0,OCI_ATTR_IS_NULL,3b535c8)=SUCCESS
OCIAttrGet(3ba0660,OCI_DTYPE_PARAM,3be13b8,7ffd7b72baac,OCI_ATTR_NAME,3b535c8)=SUCCESS
Describe col #5 type=1(VARCHAR)
Described col 5: dbtype 1(VARCHAR), scale 0, prec 4000, nullok 1, name F4
: dbsize 4000, char_used 0, char_size 4000, csid 31, csform
1(SQLCS_IMPLICIT), disize 4000
fbh 5: 'F4' NULLable, otype 1-> 5, dbsize 4000/4001, p4000.s0
OCIParamGet(3ba3190,4,3b535c8,3be1428,6,OCI_HTYPE_STMT)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be1458,0,OCI_ATTR_DATA_TYPE,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be145a,0,OCI_ATTR_DATA_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be1470,0,OCI_ATTR_CHAR_USED,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be1472,0,OCI_ATTR_CHAR_SIZE,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be1474,0,OCI_ATTR_CHARSET_ID,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be1476,0,OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be145c,0,OCI_ATTR_PRECISION,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be145e,0,OCI_ATTR_SCALE,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be145f,0,OCI_ATTR_IS_NULL,3b535c8)=SUCCESS
OCIAttrGet(3ba0610,OCI_DTYPE_PARAM,3be1460,7ffd7b72baac,OCI_ATTR_NAME,3b535c8)=SUCCESS
Describe col #6 type=1(VARCHAR)
Described col 6: dbtype 1(VARCHAR), scale 0, prec 5, nullok 0, name F5
: dbsize 5, char_used 0, char_size 5, csid 31, csform
1(SQLCS_IMPLICIT), disize 5
fbh 6: 'F5' NO null , otype 1-> 5, dbsize 5/6, p5.s0
OCIAttrSet(3ba3190,OCI_HTYPE_STMT,
7ffd7b72baa8,4,Attr=OCI_ATTR_PREFETCH_MEMORY,3b535c8)=SUCCESS
OCIAttrSet(3ba3190,OCI_HTYPE_STMT,
7ffd7b72baac,4,Attr=OCI_ATTR_PREFETCH_ROWS,3b535c8)=SUCCESS
cache settings DB Handle RowCacheSize=2097152,Statement Handle
RowCacheSize=0, OCI_ATTR_PREFETCH_ROWS=2097152, OCI_ATTR_PREFETCH_MEMORY=0,
Rows per Fetch=2097152, Multiple Row Fetch=On
OCIDefineByPos(3ba3190,3be10e8,3b535c8,1,7f2b33fc4010,172,5,7f2b33bc3010,7f2b337c2010,7f2b333c1010,mode=DEFAULT,0)=SUCCESS
OCIDefineByPos(3ba3190,3be1190,3b535c8,2,7f2b1dbc0010,172,5,7f2b1d7bf010,7f2b1d3be010,7f2b1cfbd010,mode=DEFAULT,0)=SUCCESS
OCIDefineByPos(3ba3190,3be1238,3b535c8,3,7f2b1a5bc010,21,5,7f2b1a1bb010,7f2b19dba010,7f2b199b9010,mode=DEFAULT,0)=SUCCESS
calling OCIAttrSet OCI_ATTR_CHARSET_FORM with csform=1 (SQLCS_IMPLICIT)
OCIAttrSet(3ba0118,OCI_HTYPE_DEFINE,
3be127e,0,Attr=OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
OCIDefineByPos(3ba3190,3be12e0,3b535c8,4,7f2b041b8010,172,5,7f2b03db7010,7f2b039b6010,7f2b035b5010,mode=DEFAULT,0)=SUCCESS
OCIDefineByPos(3ba3190,3be1388,3b535c8,5,7f2a0f3b4010,4001,5,7f2a0efb3010,7f2a0ebb2010,7f2a0e7b1010,mode=DEFAULT,0)=SUCCESS
calling OCIAttrSet OCI_ATTR_CHARSET_FORM with csform=1 (SQLCS_IMPLICIT)
OCIAttrSet(3b9fdc8,OCI_HTYPE_DEFINE,
3be13ce,0,Attr=OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
OCIDefineByPos(3ba3190,3be1430,3b535c8,6,7f2a0dbb0010,6,5,7f2a0d7af010,7f2a0d3ae010,7f2a0cfad010,mode=DEFAULT,0)=SUCCESS
calling OCIAttrSet OCI_ATTR_CHARSET_FORM with csform=1 (SQLCS_IMPLICIT)
OCIAttrSet(3ba1628,OCI_HTYPE_DEFINE,
3be1476,0,Attr=OCI_ATTR_CHARSET_FORM,3b535c8)=SUCCESS
dbd_describe'd 6 columns (row bytes: 4091 max, 2024 est avg, cache: 0)
<- prepare= ( AAA::DBI::Connection::st=HASH(0x3abd310) ) [1 items] at
/dirname/scriptname.pl line 186
-> execute for DBD::Oracle::st
(AAA::DBI::Connection::st=HASH(0x3abd310)~0x39f75f0) thr#24d4010
dbd_st_execute SELECT (out0, lob0)...
Statement Execute Mode is 0 (DEFAULT)
OCIStmtExecute(3b5b028,3ba3190,3b535c8,0,0,0,0,mode=DEFAULT,0)=SUCCESS
rs_array_init:imp_sth->rs_array_size=2097152, rs_array_idx=0,
prefetch_rows=0, rs_array_status=SUCCESS
OCIAttrGet(3ba3190,OCI_HTYPE_STMT,7ffd7b72bde2,0,OCI_ATTR_SQLFNCODE,3b535c8)=SUCCESS
dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0)
<- execute= ( '0E0' ) [1 items] at /dirname/scriptname.pl line 188
-> fetchrow_array for DBD::Oracle::st
(AAA::DBI::Connection::st=HASH(0x3abd310)~0x39f75f0) thr#24d4010
dbd_st_fetch 6 fields...
OCIStmtFetch(3ba3190,3b535c8,2097152,2,0)=NO_DATA
OCIAttrGet(3ba3190,OCI_HTYPE_STMT,3be0d9c,0,OCI_ATTR_ROWS_FETCHED,3b535c8)=SUCCESS
...Fetched 1030000 rows
dbih_setup_fbav alloc for 6 fields
dbih_setup_fbav now 6 fields
dbd_st_fetched 6 fields with status of 0(SUCCESS)
field #1 with rc=0(OK)
3abd340 (field=0): '1043564'
field #2 with rc=0(OK)
3abd340 (field=1): '5964'
field #3 with rc=0(OK)
3abd340 (field=2): 'sampl...'
field #4 with rc=0(OK)
3abd340 (field=3): '1'
field #5 with rc=1405(NULL)
3abd340 (field=4): undef
field #6 with rc=0(OK)
3abd340 (field=5): 'en_US'
<- fetchrow_array= ( '1043564' '5964' 'sampledatabbb' '1' undef 'en_US' )
[6 items] row1 at /dirname/scriptname.pl line 196
-> fetchrow_array for DBD::Oracle::st
(AAA::DBI::Connection::st=HASH(0x3abd310)~0x39f75f0) thr#24d4010
dbd_st_fetch 6 fields...
dbd_st_fetched 6 fields with status of 0(SUCCESS)
field #1 with rc=0(OK)
3abd340 (field=0): '1053556'
field #2 with rc=0(OK)
3abd340 (field=1): '5965'
field #3 with rc=0(OK)
3abd340 (field=2): 'sampl...'
field #4 with rc=0(OK)
3abd340 (field=3): '1'
field #5 with rc=1405(NULL)
3abd340 (field=4): undef
field #6 with rc=0(OK)
3abd340 (field=5): 'en_US'
<- fetchrow_array= ( '1053556' '5965' 'sampledatabbb' '1' undef 'en_US' )
[6 items] row2 at /dirname/scriptname.pl line 196
-> fetchrow_array for DBD::Oracle::st
(AAA::DBI::Connection::st=HASH(0x3abd310)~0x39f75f0) thr#24d4010
dbd_st_fetch 6 fields...
dbd_st_fetched 6 fields with status of 0(SUCCESS)
field #1 with rc=0(OK)
3abd340 (field=0): '1432629'
field #2 with rc=0(OK)
3abd340 (field=1): '5969'
field #3 with rc=0(OK)
3abd340 (field=2): 'datad...'
field #4 with rc=0(OK)
