And, also with the log level set to 15 here are the LAST 200 lines
3abd340 (field=0): '1127646'
field #2 with rc=0(OK)
3abd340 (field=1): '1268251'
field #3 with rc=0(OK)
3abd340 (field=2): 'a...'
field #4 with rc=0(OK)
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)
John,
Thanks for the ideas to change the cache params - I will try that!
Here is the SQL and the field types:
SELECT
d.ROW_NUMBER,
d.f1,
d.f2,
d.f3,
d.f4,
d.f5
FROM
(
SELECT /*+ FULL(A) PARALLEL(A 6) */
rownum ROW_NUMBER,
A.field1 f1 ,
Well it will be in either one of two .c files dbdimp.c or oci8.c The XS side
of things Oracle.xs is not used very much.
The level 15 debug will get deep inside the c to see where it is happening. The
trace you gave is a little high level
you are right ORA-01403 dose not make much sense